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: Quantos civis morreram no conflito que deixou 178, excluindo estrangeiros, mortos?
 ###Tabelas: CREATE TABLE performances_by_clubs (performances_by_clubs_id AUTO_INCREMENT PRIMARY KEY, # INT, Nation VARCHAR, Winners INT, Runners-up INT, 3rd Place INT, 4th Place INT) CREATE TABLE provincial_results (provincial_results_id AUTO_INCREMENT PRIMARY KEY, Province VARCHAR, Mahmoud Ahmadinejad INT, Mehdi Karroubi INT, Mir-Hossein Mousavi INT, Mohsen Rezaee INT, Spoiled ballots INT, Total votes INT) CREATE TABLE music_videos (music_videos_id AUTO_INCREMENT PRIMARY KEY, Song VARCHAR, Artist VARCHAR, Album VARCHAR, Director VARCHAR, Year INT) CREATE TABLE regular_conflicts (regular_conflicts_id AUTO_INCREMENT PRIMARY KEY, Military deaths VARCHAR, Civilian deaths VARCHAR, Total deaths (not including foreigners) VARCHAR, Military and/or Civilian wounded VARCHAR, Total casualties VARCHAR) CREATE TABLE third_qualifying_round (third_qualifying_round_id AUTO_INCREMENT PRIMARY KEY, Team 1 VARCHAR, Agg. VARCHAR, Team 2 VARCHAR, 1st leg VARCHAR, 2nd leg VARCHAR)  
SELECT Civilian deaths FROM regular_conflicts WHERE Total deaths (not including foreigners) = 178