What is the highest Total Medals that has 0 Gold Medal and a Ensemble of east 80 indoor percussion?
CREATE TABLE table_name_27 (total_medals INTEGER, gold_medals VARCHAR, ensemble VARCHAR)
SELECT MAX(total_medals) FROM table_name_27 WHERE gold_medals = 0 AND ensemble = "east 80 indoor percussion"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_27 (total_medals INTEGER, gold_medals VARCHAR, ensemble VARCHAR) Question: What is the highest Total Medals that has 0 Gold Medal and a Ensemble of east 80 indoor percussion? [/INST] SELECT MAX(total_medals) FROM table_name_27 WHERE gold_medals = 0 AND ensemble = "east 80 indoor percussion" </s>