CREATE TABLE table_name_41 (military_deaths VARCHAR2, military_and_or_civilian_wounded VARCHAR2, total_deaths VARCHAR2)

What is the total number of military deaths when there are 78 military and/or civilian wounded and more than 27 total deaths?
SELECT COUNT(military_deaths) FROM table_name_41 WHERE military_and_or_civilian_wounded = "78" AND total_deaths > 27
SELECT COUNT("military_deaths") FROM "table_name_41" WHERE "78" = "military_and_or_civilian_wounded" AND "total_deaths" > 27