user: ### NOW ANSWER:
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?
Columns: ['Israeli deaths', 'Other deaths', 'Total deaths', 'Israeli and/or foreigner wounded', 'Total casualties']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [0.0, '0', '0', '3', '3']
SQL:

assistant: SELECT "Total deaths" FROM "Table" WHERE "Israeli and/or foreigner wounded" = '0' AND "Other deaths" = '0' AND "Total casualties" = '1';