Table: olympic_bmx_results_2
Columns: rank
name
1st_run
2nd_run
3rd_run
total

Question: Which Rank has a 2nd run of 1:17.170 (8)?
SQL: SELECT MAX("rank") FROM olympic_bmx_results_2 WHERE "2nd_run" = '1:17.170 (8)'

Question: Which Rank has a Total smaller than 10, and a 3rd run of 36.457 (2)?
SQL: SELECT MAX("rank") FROM olympic_bmx_results_2 WHERE "total" < 10 AND "3rd_run" = '36.457 (2)'

Question: Which Name has a 3rd run of 36.200 (1)?
SQL: SELECT "name" FROM olympic_bmx_results_2 WHERE "3rd_run" = '36.200 (1)'