Table: israeli_war_casualties_3
Columns: military_deaths
civilian_deaths_including_foreigners
total_deaths
military_and_or_civilian_wounded
total_casualties

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 israeli_war_casualties_3 WHERE "military_and_or_civilian_wounded" = '78' AND "total_deaths" > 27

Question: What is the average number of military deaths when there are fewer than 38 civilian deaths (including foreigners) and 33 military and/or civilian wounded?
SQL: SELECT AVG("military_deaths") FROM israeli_war_casualties_3 WHERE "civilian_deaths_including_foreigners" < 38 AND "military_and_or_civilian_wounded" = '33'

Question: What is the total number of casualties when there are 12 total deaths and more than 1 military death?
SQL: SELECT "total_casualties" FROM israeli_war_casualties_3 WHERE "total_deaths" = 12 AND "military_deaths" > 1