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, and sort X-axis in asc order.
SELECT Country, COUNT(*) FROM perpetrator GROUP BY Country ORDER BY Country
SELECT "Country", COUNT(*) FROM "perpetrator" GROUP BY "Country" ORDER BY "Country" NULLS FIRST