Table: scop_event_results
Columns: dateca
event
event_2
winner
prize
entries
prize_pool
elapsed_time

Question: What is the winner in event number 15h?
SQL: SELECT "winner" FROM scop_event_results WHERE "event" = '15H'

Question: Who is the winner with an elapsed time of 12 h 42 min?
SQL: SELECT "winner" FROM scop_event_results WHERE "elapsed_time" = '12 h 42 min'

Question: What is the prize for the elapsed time of 10 h 10 min?
SQL: SELECT "prize" FROM scop_event_results WHERE "elapsed_time" = '10 h 10 min'

Question: Who is the winner of event # 1h and dateca is Apr 2?
SQL: SELECT "winner" FROM scop_event_results WHERE "dateca" = 'Apr 2' AND "event" = '1H'

Question: What is the event # when the winner is what is 7x6?
SQL: SELECT "event" FROM scop_event_results WHERE "winner" = 'what is 7x6'