A stacked bar chart shows the total number of ships with different nationalities and split by ship type, order by the Nationality from low to high.
CREATE TABLE mission (
    Mission_ID int,
    Ship_ID int,
    Code text,
    Launched_Year int,
    Location text,
    Speed_knots int,
    Fate text
)

CREATE TABLE ship (
    Ship_ID int,
    Name text,
    Type text,
    Nationality text,
    Tonnage int
)
SELECT Nationality, COUNT(Nationality) FROM ship GROUP BY Type, Nationality ORDER BY Nationality
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: A stacked bar chart shows the total number of ships with different nationalities and split by ship type, order by the Nationality from low to high. ### Input: CREATE TABLE mission (
    Mission_ID int,
    Ship_ID int,
    Code text,
    Launched_Year int,
    Location text,
    Speed_knots int,
    Fate text
)

CREATE TABLE ship (
    Ship_ID int,
    Name text,
    Type text,
    Nationality text,
    Tonnage int
) ### Response: SELECT Nationality, COUNT(Nationality) FROM ship GROUP BY Type, Nationality ORDER BY Nationality