What are the countries of perpetrators? Show each country and the corresponding number of perpetrators there Plot them as bar chart, and could you sort total number in ascending order please?
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(*)
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 could you sort total number in ascending order please? ### 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(*)