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?
SQL: SELECT COUNT(military_deaths) FROM table_name_41 WHERE military_and_or_civilian_wounded = "78" AND total_deaths > 27