What are the names of the perpetrators in the country China?
select t1.name from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id where t2.country = "China"
What are the names of the perpetrators in the country Japan?
select t1.name from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id where t2.country = "Japan"
What are the heights of all the perpetrators in Japan and China?
select t1.height from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id where t2.country = "China" or t2.country = "Japan"
What are the weights of all the perpetrators from South Korea?
select t1.weight from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id where t2.country = "South Korea"