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

Question: What average total has 41.241 (3) as the 1st run?
SQL: SELECT AVG("total") FROM olympic_bmx_results WHERE "1st_run" = '41.241 (3)'

Question: How many totals have 38.023 (6) as the 3rd run?
SQL: SELECT COUNT("total") FROM olympic_bmx_results WHERE "3rd_run" = '38.023 (6)'

Question: What name has a rank less than 3, with 36.076 (1) as the 3rd run?
SQL: SELECT "name" FROM olympic_bmx_results WHERE "rank" < 3 AND "3rd_run" = '36.076 (1)'