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 are the countries of perpetrators? Show each country and the corresponding number of perpetrators there.
assistant
SELECT Country , COUNT( * ) FROM perpetrator GROUP BY Country ;
human
Which country has the fewest perpetrators?
assistant
SELECT Country , COUNT( * ) FROM perpetrator GROUP BY Country ORDER BY COUNT( * ) ASC LIMIT 1 ;