Show me the number of people killed by each perpetrator.
select killed from perpetrator;
Order the result in descending order.
select killed from perpetrator order by killed desc ;
What's the location for the one who killed the most people?
select location from perpetrator order by killed desc limit 1;