CREATE TABLE table_name_78 (total_deaths VARCHAR2, total_casualties VARCHAR2, israeli_and_or_foreigner_wounded VARCHAR2, other_deaths VARCHAR2)

What is the total number of deaths of the attack with 0 Israelis or foreigners wounded, 0 other deaths, and a total casualty of 1?
SELECT total_deaths FROM table_name_78 WHERE israeli_and_or_foreigner_wounded = "0" AND other_deaths = "0" AND total_casualties = "1"
SELECT "total_deaths" FROM "table_name_78" WHERE "0" = "israeli_and_or_foreigner_wounded" AND "0" = "other_deaths" AND "1" = "total_casualties"