Show me the location for each perpetrator.
select location from perpetrator;
What are the distinct locations?
select distinct location from perpetrator;
How many are there in the result?
select count(distinct location) from perpetrator;