Table: war_casualties
Columns: israeli_deaths
other_deaths
total_deaths
israeli_and_or_foreigner_wounded
total_casualties

Question: 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?
SQL: SELECT "total_deaths" FROM war_casualties WHERE "israeli_and_or_foreigner_wounded" = '0' AND "other_deaths" = '0' AND "total_casualties" = '1'

Question: How many Israelis and or foreigners were wounded in the attack with more than 1 Israeli death?
SQL: SELECT "israeli_and_or_foreigner_wounded" FROM war_casualties WHERE "israeli_deaths" > 1

Question: How many other deaths were in the attack with 242 Israelis and/or foreigners wounded?
SQL: SELECT "other_deaths" FROM war_casualties WHERE "israeli_and_or_foreigner_wounded" = '242'

Question: What is the total number of Israeli deaths in the attack with 0 total casulaties and 0 total deaths?
SQL: SELECT COUNT("israeli_deaths") FROM war_casualties WHERE "total_casualties" = '0' AND "total_deaths" = '0'