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
What are the number of people injured for each perpetrator?
assistant
SELECT T1.Name , T2.Injured FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID = T2.People_ID ;
human
What are the heights of each perpetrator 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 ;