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)

Visualize a pie chart with what are the countries of perpetrators? Show each country and the corresponding number of perpetrators there.
SELECT Country, COUNT(*) FROM perpetrator GROUP BY Country
SELECT "Country", COUNT(*) FROM "perpetrator" GROUP BY "Country"