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

Bar chart x axis country y axis the total number, list total number from high to low order.
SELECT Country, COUNT(*) FROM perpetrator GROUP BY Country ORDER BY COUNT(*) DESC
SELECT "Country", COUNT(*) FROM "perpetrator" GROUP BY "Country" ORDER BY COUNT(*) DESC NULLS LAST