Table: olympic_womens_pursuit
Columns: rank
heat
cyclist
nation
result

Question: What is the total heat ranked higher than 7?
SQL: SELECT SUM("heat") FROM olympic_womens_pursuit WHERE "rank" > 7

Question: Which cyclist is from Australia?
SQL: SELECT "cyclist" FROM olympic_womens_pursuit WHERE "nation" = 'australia'

Question: Which nation has a heat of 4, and is ranked 8?
SQL: SELECT "nation" FROM olympic_womens_pursuit WHERE "heat" = 4 AND "rank" = 8