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

Question: What is the trans 2 duration if the biking stage is covered within 58:20?
SQL: SELECT "trans_2" FROM swiss_olympics_2008 WHERE "bike_40km" = '58:20'

Question: What is the trans 2 duration if the total time is 1:51:19.45?
SQL: SELECT "trans_2" FROM swiss_olympics_2008 WHERE "total_time" = '1:51:19.45'

Question: What was the duration of Daniela Ryf's swimming stage?
SQL: SELECT "swim_1_5km" FROM swiss_olympics_2008 WHERE "athlete" = 'Daniela Ryf'

Question: How many athletes completed a trans 1 within 0:26?
SQL: SELECT COUNT("athlete") FROM swiss_olympics_2008 WHERE "trans_1" = '0:26'

Question: Who was the athlete that covered biking within 58:52?
SQL: SELECT "athlete" FROM swiss_olympics_2008 WHERE "bike_40km" = '58:52'