Show me the names of the perpetrators.
select t1.name from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id;
Who has the largest height?
select t1.name from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id order by t1.height desc limit 1;
How about the highest weight?
select t1.name from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id order by t1.weight desc limit 1;