What are the number of people injured for each perpetrator?
select t1.name, t2.injured from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id;
What are the heights of each perpetrator in descending order of the number of people they injured?
select t1.height from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id order by t2.injured desc;