user: ### NOW ANSWER:
Question: How many gold medals for the school with less than 1 total?
Columns: ['Ensemble', 'Gold Medals', 'Silver Medals', 'Bronze Medals', 'Total Medals']
Types: ['text', 'real', 'real', 'real', 'real']
Sample row: ['Victor J. Andrew HS', 0.0, 1.0, 0.0, 1.0]
SQL:

assistant: SELECT COUNT("Gold Medals") FROM "Table" WHERE "Total Medals" < 1.0;