CREATE TABLE people (Name VARCHAR2, People_ID VARCHAR2)
CREATE TABLE perpetrator (People_ID VARCHAR2, Country VARCHAR2)

What are the names of perpetrators in country 'China' or 'Japan'?
SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Country = "China" OR T2.Country = "Japan"
SELECT "T1"."Name" FROM "people" "T1" JOIN "perpetrator" "T2" ON ("China" = "T2"."Country" OR "Japan" = "T2"."Country") AND "T1"."People_ID" = "T2"."People_ID"