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 perpetrators are there?
assistant
SELECT count(*) FROM perpetrator
human
What is the total kills of the perpetrators with height more than 1.84.
assistant
SELECT sum(T2.Killed) FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID = T2.People_ID WHERE T1.Height > 1.84
human
List the date of perpetrators in descending order of the number of people killed.
assistant
SELECT Date FROM perpetrator ORDER BY Killed DESC
human
What is the average number of people injured by all perpetrators?
assistant
SELECT avg(Injured) FROM perpetrator
human
List the number of people injured by perpetrators in ascending order.
assistant
SELECT Injured FROM perpetrator ORDER BY Injured ASC
human
What are the heights of perpetrators in descending order of the number of people they injured?
assistant
SELECT T1.Height FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID = T2.People_ID ORDER BY T2.Injured DESC ;