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

Question: For what total was 37.410 (4) the 1st run?
SQL: SELECT "total" FROM olympic_bmx_results_2 WHERE "1st_run" = '37.410 (4)'

Question: Who had a 2nd run of 39.296 (5)?
SQL: SELECT "name" FROM olympic_bmx_results_2 WHERE "2nd_run" = '39.296 (5)'

Question: What is the greatest total when the 3rd run was 48.734 (8)?
SQL: SELECT MAX("total") FROM olympic_bmx_results_2 WHERE "3rd_run" = '48.734 (8)'

Question: What is the 3rd run was 41.256 (6) the 2nd run?
SQL: SELECT "3rd_run" FROM olympic_bmx_results_2 WHERE "2nd_run" = '41.256 (6)'

Question: With a 3rd run of 37.805 (6), what was the 1st run?
SQL: SELECT "1st_run" FROM olympic_bmx_results_2 WHERE "3rd_run" = '37.805 (6)'

Question: What is the 1st run when 37.496 (4) is the 3rd run?
SQL: SELECT "1st_run" FROM olympic_bmx_results_2 WHERE "3rd_run" = '37.496 (4)'