What is the total number of military deaths when there are 78 military and/or civilian wounded and more than 27 total deaths?
CREATE TABLE table_name_41 (military_deaths VARCHAR, military_and_or_civilian_wounded VARCHAR, total_deaths VARCHAR)
SELECT COUNT(military_deaths) FROM table_name_41 WHERE military_and_or_civilian_wounded = "78" AND total_deaths > 27
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_41 (military_deaths VARCHAR, military_and_or_civilian_wounded VARCHAR, total_deaths VARCHAR) Question: What is the total number of military deaths when there are 78 military and/or civilian wounded and more than 27 total deaths? [/INST] SELECT COUNT(military_deaths) FROM table_name_41 WHERE military_and_or_civilian_wounded = "78" AND total_deaths > 27 </s>