Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual é o número total de mortes militares quando há 78 militares e/ou civis feridos e mais de 27 mortes no total?
 ###Tabelas: CREATE TABLE background (background_id AUTO_INCREMENT PRIMARY KEY, Model VARCHAR, A300 VARCHAR, A310 VARCHAR, A320 VARCHAR, A330 VARCHAR, A340 VARCHAR) CREATE TABLE league_and_cup_history (league_and_cup_history_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, LeagueContested VARCHAR, Level INT, LeaguePosition VARCHAR, Avg.Home Attendance 1 VARCHAR, FA Cup VARCHAR, FA Trophy VARCHAR, Leading scorer 1 VARCHAR) CREATE TABLE football_rivalries (football_rivalries_id AUTO_INCREMENT PRIMARY KEY, Teams VARCHAR, Name VARCHAR, Trophy VARCHAR, First met INT, Games played VARCHAR, Series record VARCHAR) CREATE TABLE terror_and_other_attacks_1968–1987 (terror_and_other_attacks_1968–1987_id AUTO_INCREMENT PRIMARY KEY, Military deaths INT, Civilian deaths (including foreigners) INT, Total deaths INT, Military and/or Civilian wounded VARCHAR, Total casualties VARCHAR) CREATE TABLE list_of_representatives_who_resigned (list_of_representatives_who_resigned_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Party VARCHAR, Date of resignation VARCHAR, Replacement VARCHAR, Notes VARCHAR)  
SELECT COUNT Military deaths FROM terror_and_other_attacks_1968–1987 WHERE Military and/or Civilian wounded = 78 AND Total deaths > 27