Table: water_polo_pan_american
Columns: rank
gold
silver
bronze
total

Question: How many gold medals correspond with a total over 4?
SQL: SELECT "gold" FROM water_polo_pan_american WHERE "total" > 4

Question: What is the sum of gold medals with a total of 12 medals and less than 4 bronze medals?
SQL: SELECT SUM("gold") FROM water_polo_pan_american WHERE "total" = 12 AND "bronze" < 4

Question: What is the smallest number of gold medals corresponding to the total rank with more than 4 bronze medals?
SQL: SELECT MIN("gold") FROM water_polo_pan_american WHERE "rank" = 'total' AND "bronze" > 4

Question: What is the smallest number of bronze medals with more than 4 gold medals?
SQL: SELECT MIN("bronze") FROM water_polo_pan_american WHERE "gold" > 4