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
Show me the number of people killed by each perpetrator.
assistant
SELECT Killed FROM perpetrator ;
human
Order the result in descending order.
assistant
SELECT Killed FROM perpetrator ORDER BY Killed DESC ;
human
What's the location for the one who killed the most people?
assistant
SELECT LOCATION FROM perpetrator ORDER BY Killed DESC LIMIT 1 ;