For each perpetrator, show the year that corresponds?
select year from perpetrator;
Show me their names.
select t1.name from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id;
Sort the result in descending order by year.
select t1.name from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id order by t2.year desc;