Table: fei_2010_games
Columns: rank
nation
gold
silver
bronze
total

Question: Which rank has a total less than 9, less than 2 bronze, and from France?
SQL: SELECT "rank" FROM fei_2010_games WHERE "total" < 9 AND "bronze" < 2 AND "nation" = 'france'

Question: Which rank has more than 1 silver, more than 1 gold, and more than 4 bronze?
SQL: SELECT "rank" FROM fei_2010_games WHERE "silver" > 1 AND "gold" > 1 AND "bronze" > 4

Question: How many silver have a Total smaller than 3, a Bronze of 1, and a Gold larger than 0?
SQL: SELECT MAX("silver") FROM fei_2010_games WHERE "total" < 3 AND "bronze" = 1 AND "gold" > 0

Question: How many gold have a National of New Zealand with a total less than 2?
SQL: SELECT SUM("gold") FROM fei_2010_games WHERE "nation" = 'new zealand' AND "total" < 2