Show me all about people.
select * from people;
Which of those are perpetrators?
select name from people where people_id in (select people_id from perpetrator);
Show the rest of peoples' names.
select name from people where people_id not in (select people_id from perpetrator);