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
HOW MANY PEOPLE HAS KILLED AT SOUTH KOREA ?
assistant
SELECT killed FROM perpetrator WHERE Country = 'South Korea';
human
WHAT IS THE NAME OF THE PERPETRATOR WITH THE BIGGEST WEIGHT ?
assistant
SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID = T2.People_ID ORDER BY T1.Weight DESC LIMIT 1;
human
WHERE IS THE LOCATION OF EVENTS IN JAPAN ?
assistant
SELECT Location FROM perpetrator WHERE Country = "Japan" ;