What is the total number of casualties when there are 12 total deaths and more than 1 military death?
CREATE TABLE table_name_47 (total_casualties VARCHAR, total_deaths VARCHAR, military_deaths VARCHAR)
SELECT total_casualties FROM table_name_47 WHERE total_deaths = 12 AND military_deaths > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (total_casualties VARCHAR, total_deaths VARCHAR, military_deaths VARCHAR) Question: What is the total number of casualties when there are 12 total deaths and more than 1 military death? [/INST] SELECT total_casualties FROM table_name_47 WHERE total_deaths = 12 AND military_deaths > 1 </s>