Table: swimming_1980_olympics_womens
Columns: rank
heat
name
nationality
time

Question: What is the time when the rank is 14?
SQL: SELECT "time" FROM swimming_1980_olympics_womens WHERE "rank" = 14

Question: what is the rank when the time is 3:12.40?
SQL: SELECT SUM("rank") FROM swimming_1980_olympics_womens WHERE "time" = '3:12.40'

Question: what is the rank when the heat is more than 4?
SQL: SELECT SUM("rank") FROM swimming_1980_olympics_womens WHERE "heat" > 4

Question: what is the nationality when the heat is less than 3 and the time is 2:35.31?
SQL: SELECT "nationality" FROM swimming_1980_olympics_womens WHERE "heat" < 3 AND "time" = '2:35.31'

Question: what is the name when the heat is less than 3, the rank is less than 18, the nationality is east germany and the time is 2:35.31?
SQL: SELECT "name" FROM swimming_1980_olympics_womens WHERE "heat" < 3 AND "rank" < 18 AND "nationality" = 'east germany' AND "time" = '2:35.31'