user: ### NOW ANSWER:
Question: Name the average total medals with ensemble of Goshen HS
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("Total Medals") FROM "Table" WHERE "Ensemble" = 'Goshen HS';