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
For each perpetrator, show the ids and his or her country.
assistant
SELECT Country , Perpetrator_ID FROM perpetrator ;
human
Also, show how many they have each injured.
assistant
SELECT Country , Perpetrator_ID , Injured FROM perpetrator ;
human
Which countries have perpetrators who have injured more than 50?
assistant
SELECT Country FROM perpetrator WHERE Injured > 50 ;