Table: winter_guard_medals
Columns: ensemble
gold_medals
silver_medals
bronze_medals
total_medals

Question: How many gold medals does the Choctawhatchee High School have?
SQL: SELECT MAX("gold_medals") FROM winter_guard_medals WHERE "ensemble" = 'Choctawhatchee High School'

Question: How many gold medals does each school who has a total of 1 medal have?
SQL: SELECT "gold_medals" FROM winter_guard_medals WHERE "total_medals" = 1