What are the countries of perpetrators? Show each country and the corresponding number of perpetrators there.
select country, count(*) from perpetrator group by country;
Which country has the fewest perpetrators?
select country, count(*) from perpetrator group by country order by count(*) asc limit 1;
How about the most?
select country, count(*) from perpetrator group by country order by count(*) desc limit 1;