Table: swiss_olympics_2008_2
Columns: athlete
event
swim_1_5km
trans_1
bike_40km
trans_2
run_10km
total_time
rank

Question: What is the time for the bike (40km) when the swim (1.5km) is 19:56?
SQL: SELECT "bike_40km" FROM swiss_olympics_2008_2 WHERE "swim_1_5km" = '19:56'

Question: With a swim (1.5km) of 18:55 and a run (10km) of 32:37, what is the trans 2?
SQL: SELECT "trans_2" FROM swiss_olympics_2008_2 WHERE "swim_1_5km" = '18:55' AND "run_10km" = '32:37'

Question: Daniela Ryf who competes in the women's even had what swim (1.5km)?
SQL: SELECT "swim_1_5km" FROM swiss_olympics_2008_2 WHERE "event" = 'women''s' AND "athlete" = 'daniela ryf'

Question: For the triathlon with a bike (40km) of 58:20 what is the total time?
SQL: SELECT "total_time" FROM swiss_olympics_2008_2 WHERE "bike_40km" = '58:20'

Question: How long did the trans 1 take when 2:00:40.20 is the total time?
SQL: SELECT "trans_1" FROM swiss_olympics_2008_2 WHERE "total_time" = '2:00:40.20'