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)

Bar chart x axis country y axis the total number, sort x-axis in descending order please.
SELECT Country, COUNT(*) FROM perpetrator GROUP BY Country ORDER BY Country DESC
SELECT "Country", COUNT(*) FROM "perpetrator" GROUP BY "Country" ORDER BY "Country" DESC