Hi - can you please list the names of perpetrators in all countries except for China?
select t1.name from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id where t2.country ! = "China"
Great - I forgot to ask, can you please show which countries each of the listed perpetrators are associated with?
select t1.name, t2.country from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id where t2.country ! = "China"
Fantastic - what was the total number of perpetrators in China?
select count ( * ) from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id where t2.country = "China"