Table: water_polo_pan_american
Columns: rank
gold
silver
bronze
total

Question: How many gold are a rank 1 and larger than 16?
SQL: SELECT COUNT("gold") FROM water_polo_pan_american WHERE "rank" = '1' AND "total" > 16

Question: How many total gold are less than 4?
SQL: SELECT COUNT("gold") FROM water_polo_pan_american WHERE "total" < 4

Question: What is the total gold that has bronze less than 2, a silver of 1 and total more than 4?
SQL: SELECT SUM("gold") FROM water_polo_pan_american WHERE "bronze" < 2 AND "silver" = 1 AND "total" > 4