Table: skating_medals
Columns: rank
nation
gold
silver
bronze
total

Question: What rank has 1 silver, more than 2 gold, and a total larger than 3?
SQL: SELECT COUNT("rank") FROM skating_medals WHERE "silver" = 1 AND "total" > 3 AND "gold" > 2

Question: What is the most gold where silver is 0?
SQL: SELECT MAX("gold") FROM skating_medals WHERE "silver" < 0

Question: What is the number of silver where the rank is higher than 4 and bronze is smaller than 1?
SQL: SELECT COUNT("silver") FROM skating_medals WHERE "rank" > 4 AND "bronze" < 1

Question: What is the rank where the gold is 0?
SQL: SELECT AVG("rank") FROM skating_medals WHERE "gold" < 0

Question: What is the rank that has 1 bronze and 1 silver?
SQL: SELECT COUNT("rank") FROM skating_medals WHERE "bronze" = 1 AND "silver" > 1