Table: world_short_track_2008
Columns: rank
nation
gold
silver
bronze
total

Question: What is Nation, when Rank is greater than 2, when Total is greater than 1, and when Bronze is less than 3?
SQL: SELECT "nation" FROM world_short_track_2008 WHERE "rank" > 2 AND "total" > 1 AND "bronze" < 3

Question: What is the average Silver, when Rank is 5, and when Bronze is less than 1?
SQL: SELECT AVG("silver") FROM world_short_track_2008 WHERE "rank" = 5 AND "bronze" < 1

Question: What is the lowest Rank, when Nation is Great Britain, and when Bronze is less than 1?
SQL: SELECT MIN("rank") FROM world_short_track_2008 WHERE "nation" = 'great britain' AND "bronze" < 1

Question: What is the total number of Gold, when Silver is 2, and when Total is less than 7?
SQL: SELECT COUNT("gold") FROM world_short_track_2008 WHERE "silver" = 2 AND "total" < 7

Question: What is the lowest Gold, when Nation is Canada, and when Rank is greater than 4?
SQL: SELECT MIN("gold") FROM world_short_track_2008 WHERE "nation" = 'canada' AND "rank" > 4