Table: winter_guard_medals_3
Columns: ensemble
gold_medals
silver_medals
bronze_medals
total_medals

Question: Name the average gold medals when the bronze medals was less than 1, silver medals being 0 and total medals more than 1
SQL: SELECT AVG("gold_medals") FROM winter_guard_medals_3 WHERE "bronze_medals" < 1 AND "silver_medals" = 0 AND "total_medals" > 1

Question: Name the total number of bronze medals when gold medals was 2, total medals more than 4 and silver medals less than 5
SQL: SELECT COUNT("bronze_medals") FROM winter_guard_medals_3 WHERE "gold_medals" = 2 AND "total_medals" > 4 AND "silver_medals" < 5

Question: Name the ensemble with silver medals more than 1
SQL: SELECT "ensemble" FROM winter_guard_medals_3 WHERE "silver_medals" > 1

Question: Name the average total medals with ensemble of goshen hs
SQL: SELECT AVG("total_medals") FROM winter_guard_medals_3 WHERE "ensemble" = 'goshen hs'