Table: nz_commonwealth_games_medals
Columns: sport
gold
silver
bronze
total

Question: How many gold values have totals over 30, bronzes over 35, and are in Swimming?
SQL: SELECT COUNT("gold") FROM nz_commonwealth_games_medals WHERE "total" > 30 AND "sport" = 'swimming' AND "bronze" > 35

Question: What is the highest bronze value with silvers over 2, golds under 16, and in Cycling?
SQL: SELECT MAX("bronze") FROM nz_commonwealth_games_medals WHERE "silver" > 2 AND "sport" = 'cycling' AND "gold" < 16

Question: What is the total associated with Bronzes over 35?
SQL: SELECT "total" FROM nz_commonwealth_games_medals WHERE "bronze" > 35

Question: What is the smallest bronze value associated with golds over 0, silvers over 11, and totals of 36?
SQL: SELECT MIN("bronze") FROM nz_commonwealth_games_medals WHERE "gold" > 0 AND "total" = 36 AND "silver" > 11

Question: What is the average number of golds in athletics associated with over 42 silvers?
SQL: SELECT AVG("gold") FROM nz_commonwealth_games_medals WHERE "sport" = 'athletics' AND "silver" > 42

Question: What is the smallest number of silvers associated with bronzes under 20, totals of 1, golds of 0, and in Water Polo?
SQL: SELECT MIN("silver") FROM nz_commonwealth_games_medals WHERE "bronze" < 20 AND "total" = 1 AND "sport" = 'water polo' AND "gold" < 0