What are the countries of perpetrators? Show each country and the corresponding number of perpetrators there Plot them as bar chart, and rank by the x-axis from high to low.
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 Country 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 rank by the x-axis from high to low. ### 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 Country DESC