Compare the total number of each fate with a bar chart, and display Y-axis from low to high order.
CREATE TABLE ship (
    Ship_ID int,
    Name text,
    Type text,
    Nationality text,
    Tonnage int
)

CREATE TABLE mission (
    Mission_ID int,
    Ship_ID int,
    Code text,
    Launched_Year int,
    Location text,
    Speed_knots int,
    Fate text
)
SELECT Fate, COUNT(Fate) FROM mission GROUP BY Fate ORDER BY COUNT(Fate)
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: Compare the total number of each fate with a bar chart, and display Y-axis from low to high order. ### Input: CREATE TABLE ship (
    Ship_ID int,
    Name text,
    Type text,
    Nationality text,
    Tonnage int
)

CREATE TABLE mission (
    Mission_ID int,
    Ship_ID int,
    Code text,
    Launched_Year int,
    Location text,
    Speed_knots int,
    Fate text
) ### Response: SELECT Fate, COUNT(Fate) FROM mission GROUP BY Fate ORDER BY COUNT(Fate)