Table: winter_guard_medals_5
Columns: ensemble
gold_medals
silver_medals
bronze_medals
total_medals

Question: What was the average total medals received by Roland Hayes School when there were 0 gold medals?
SQL: SELECT AVG("total_medals") FROM winter_guard_medals_5 WHERE "gold_medals" = 0 AND "ensemble" = 'roland hayes school'

Question: What was the total number of medals received by James Logan High School when it received less than 1 silver medal?
SQL: SELECT COUNT("total_medals") FROM winter_guard_medals_5 WHERE "ensemble" = 'james logan high school' AND "silver_medals" < 1

Question: What is the highest number of bronze medals received by an ensemble who received fewer than 0 gold medals?
SQL: SELECT MAX("bronze_medals") FROM winter_guard_medals_5 WHERE "gold_medals" < 0