Table: winter_guard_medals_3
Columns: ensemble
gold_medals
silver_medals
bronze_medals
total_medals

Question: What is the highest Total Medals that has 0 Gold Medal and a Ensemble of east 80 indoor percussion?
SQL: SELECT MAX("total_medals") FROM winter_guard_medals_3 WHERE "gold_medals" = 0 AND "ensemble" = 'east 80 indoor percussion'

Question: What is the lowest Total Medals that has madison independent and Bronze Medals larger than 0
SQL: SELECT MIN("total_medals") FROM winter_guard_medals_3 WHERE "ensemble" = 'madison independent' AND "bronze_medals" > 0

Question: what is Gold Medals that has  salem blue devils and a Silver Medals less than 1?
SQL: SELECT MIN("gold_medals") FROM winter_guard_medals_3 WHERE "ensemble" = 'salem blue devils' AND "silver_medals" < 1