Table: swimming_1951_pan_am
Columns: nation
gold
silver
bronze
total

Question: How many totals have 0 as Gold, a bronze greater than 1, and a silver less than 1?
SQL: SELECT COUNT("total") FROM swimming_1951_pan_am WHERE "gold" = 0 AND "bronze" > 1 AND "silver" < 1

Question: How many totals have brazil as the nation, and a bronze less than 2?
SQL: SELECT SUM("total") FROM swimming_1951_pan_am WHERE "nation" = 'brazil' AND "bronze" < 2

Question: How many silvers have 2 as gold, and a bronze less than 2?
SQL: SELECT SUM("silver") FROM swimming_1951_pan_am WHERE "gold" = 2 AND "bronze" < 2

Question: Which nation has a gold less than 2 and a bronze less than 5?
SQL: SELECT "nation" FROM swimming_1951_pan_am WHERE "gold" < 2 AND "bronze" < 5

Question: What is the least silver that has mexico as a nation and a gold less than 0?
SQL: SELECT MIN("silver") FROM swimming_1951_pan_am WHERE "nation" = 'mexico' AND "gold" < 0