user: ### NOW ANSWER:
Question: Name the average gold medals when the bronze medals was less than 1, silver medals being 0 and total medals more than 1
Columns: ['Ensemble', 'Gold Medals', 'Silver Medals', 'Bronze Medals', 'Total Medals']
Types: ['text', 'real', 'real', 'real', 'real']
Sample row: ['Anderson HS', 0.0, 1.0, 0.0, 1.0]
SQL:

assistant: SELECT AVG("Gold Medals") FROM "Table" WHERE "Bronze Medals" < 1.0 AND "Silver Medals" = 0.0 AND "Total Medals" > 1.0;