human
Schema:
perpetrator (Perpetrator_ID, People_ID, Date, Year, Location, Country, Killed, Injured)
people (People_ID, Name, Height, Weight, Home Town)
Please answer with SQL.
assistant
Sure, I understand.
human
Hi - can you please list the names of perpetrators in all countries except for China?
assistant
SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Country ! = 'China';
human
Great - I forgot to ask, can you please show which countries each of the listed perpetrators are associated with?
assistant
SELECT T1.Name , T2.Country FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Country ! = 'China';
human
Fantastic - what was the total number of perpetrators in China?
assistant
SELECT COUNT( * ) FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Country = "China" ;