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
How many countries are there on the list?
assistant
SELECT COUNT( Country ) FROM perpetrator;
human
Can you list the name of the countries that have perpetrators with injures more than 50?
assistant
SELECT Country FROM perpetrator WHERE Injured > 50;
human
Can you also include the name of the contries that have perpetrators with injures smaller than 20?
assistant
SELECT Country FROM perpetrator WHERE Injured < 20 ;