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

Question: Which 3rd run has rank of 8?
SQL: SELECT "3rd_run" FROM olympic_bmx_results WHERE "rank" = 8

Question: Which 3rd run has rank of 1?
SQL: SELECT "3rd_run" FROM olympic_bmx_results WHERE "rank" = 1

Question: Which average rank has a total of 16?
SQL: SELECT AVG("rank") FROM olympic_bmx_results WHERE "total" = 16