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
what is the name of people that are not perpetrators
assistant
SELECT Name FROM people WHERE People_ID NOT IN ( SELECT People_ID FROM perpetrator ) ;