human
Schema:
perpetrator (Perpetrator_ID, People_ID, Date, Year, Location, Country, Killed, Injured)
people (People_ID, Name, Height, Weight, Home Town)
Please answer with SQL.
assistant
Sure, I understand.
human
tell me the total number of injured in both china and japan
assistant
SELECT SUM( injured ) FROM perpetrator WHERE country = 'China' OR country = 'Japan';
human
what is the rate of kill in south korea
assistant
SELECT Killed FROM perpetrator WHERE country = "South Korea" ;