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

Question: What is the total sum ranked less than 5 with a 37.076 (2) 3rd run?
SQL: SELECT SUM("total") FROM olympic_bmx_women_2008 WHERE "rank" < 5 AND "3rd_run" = '37.076 (2)'

Question: What is the name of the person with a total of 22?
SQL: SELECT "name" FROM olympic_bmx_women_2008 WHERE "total" = 22

Question: What is the total with a rank less than 8 and a 40.143 (4) 2nd run?
SQL: SELECT "total" FROM olympic_bmx_women_2008 WHERE "rank" < 8 AND "2nd_run" = '40.143 (4)'