What was the average total medals received by Roland Hayes School when there were 0 gold medals?
CREATE TABLE table_name_99 (total_medals INTEGER, gold_medals VARCHAR, ensemble VARCHAR)
SELECT AVG(total_medals) FROM table_name_99 WHERE gold_medals = 0 AND ensemble = "roland hayes school"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (total_medals INTEGER, gold_medals VARCHAR, ensemble VARCHAR) Question: What was the average total medals received by Roland Hayes School when there were 0 gold medals? [/INST] SELECT AVG(total_medals) FROM table_name_99 WHERE gold_medals = 0 AND ensemble = "roland hayes school" </s>