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.
CREATE TABLE people (
    People_ID int,
    Name text,
    Height real,
    Weight real,
    "Home Town" text
)

CREATE TABLE perpetrator (
    Perpetrator_ID int,
    People_ID int,
    Date text,
    Year real,
    Location text,
    Country text,
    Killed int,
    Injured int
)
SELECT Country, COUNT(*) FROM perpetrator GROUP BY Country ORDER BY COUNT(*) DESC
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: 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. ### Input: CREATE TABLE people (
    People_ID int,
    Name text,
    Height real,
    Weight real,
    "Home Town" text
)

CREATE TABLE perpetrator (
    Perpetrator_ID int,
    People_ID int,
    Date text,
    Year real,
    Location text,
    Country text,
    Killed int,
    Injured int
) ### Response: SELECT Country, COUNT(*) FROM perpetrator GROUP BY Country ORDER BY COUNT(*) DESC