Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: 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?

### Accurate SQL ###

SELECT COUNT(military_deaths) FROM table_name_41 WHERE military_and_or_civilian_wounded = "78" AND total_deaths > 27