What is the total number of every ship type by categorizing by nationality?, and sort the number of type in ascending order.
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 Type, COUNT(Type) FROM ship GROUP BY Nationality, Type ORDER BY COUNT(Type)
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 is the total number of every ship type by categorizing by nationality?, and sort the number of type in ascending order. ### 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 Type, COUNT(Type) FROM ship GROUP BY Nationality, Type ORDER BY COUNT(Type)