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
Show me the location for each perpetrator.
assistant
SELECT Location FROM perpetrator ;
human
What are the distinct locations?
assistant
SELECT DISTINCT LOCATION FROM perpetrator ;
human
How many are there in the result?
assistant
SELECT COUNT( DISTINCT LOCATION ) FROM perpetrator ;