What is the total number of military deaths when there are 78 military and/or civilian wounded and more than 27 total deaths?
CREATE TABLE "terror_and_other_attacks_1968_1987" (
  "military_deaths" real,
  "civilian_deaths_including_foreigners" real,
  "total_deaths" real,
  "military_and_or_civilian_wounded" text,
  "total_casualties" text
);
SELECT COUNT("military_deaths") FROM "terror_and_other_attacks_1968_1987" WHERE "military_and_or_civilian_wounded"='78' AND "total_deaths">27;