Table: olympic_medals_1980
Columns: rank
nation
gold
silver
bronze
total

Question: What's the sum of gold where silver is more than 2 and the total is 12?
SQL: SELECT SUM("gold") FROM olympic_medals_1980 WHERE "silver" > 2 AND "total" = 12

Question: What's the lowest gold with a total of 4 and less than 2 silver for liechtenstein?
SQL: SELECT MIN("gold") FROM olympic_medals_1980 WHERE "total" = 4 AND "nation" = 'liechtenstein' AND "silver" < 2

Question: What's the total number of gold where the total is less than 23 and the rank is over 10?
SQL: SELECT COUNT("gold") FROM olympic_medals_1980 WHERE "total" < 23 AND "rank" > 10

Question: What's the sum of total where the rank is over 9 and the gold is less than 1?
SQL: SELECT COUNT("total") FROM olympic_medals_1980 WHERE "rank" > 9 AND "gold" < 1