Table: winter_guard_medals_4
Columns: ensemble
gold_medals
silver_medals
bronze_medals
total_medals

Question: How many gold medals for the school with 2 total medals and under 0 bronzes?
SQL: SELECT COUNT("gold_medals") FROM winter_guard_medals_4 WHERE "total_medals" = 2 AND "bronze_medals" < 0

Question: How many gold medals for bellbrook HS with less than 1 silver?
SQL: SELECT COUNT("gold_medals") FROM winter_guard_medals_4 WHERE "ensemble" = 'bellbrook hs' AND "silver_medals" < 1

Question: How many silvers for a school with 2 golds and over 2 total?
SQL: SELECT "silver_medals" FROM winter_guard_medals_4 WHERE "gold_medals" = 2 AND "total_medals" > 2

Question: How many gold medals for the school with less than 1 total?
SQL: SELECT COUNT("gold_medals") FROM winter_guard_medals_4 WHERE "total_medals" < 1