CREATE TABLE people (People_ID NUMBER, Name CLOB, Height FLOAT, Weight FLOAT, "Home Town" CLOB)
CREATE TABLE perpetrator (Perpetrator_ID NUMBER, People_ID NUMBER, Date CLOB, Year FLOAT, Location CLOB, Country CLOB, Killed NUMBER, Injured NUMBER)

What are the countries of perpetrators? Show each country and the corresponding number of perpetrators there Plot them as bar chart, and sort by the the total number in descending.
SELECT Country, COUNT(*) FROM perpetrator GROUP BY Country ORDER BY COUNT(*) DESC
SELECT "Country", COUNT(*) FROM "perpetrator" GROUP BY "Country" ORDER BY COUNT(*) DESC