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)

Give me a stacked bar chart for showing the total number of each ship type and categorize it by ship nationality, could you list in ascending by the x-axis?
SELECT Type, COUNT(Type) FROM ship GROUP BY Nationality, Type ORDER BY Type
SELECT "Type", COUNT("Type") FROM "ship" GROUP BY "Nationality", "Type" ORDER BY "Type" NULLS FIRST