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)

What is the total number of each ship type? Give me a bar chart, I want to show from low to high by the y axis.
SELECT Type, COUNT(Type) FROM ship GROUP BY Type ORDER BY COUNT(Type)
SELECT "Type", COUNT("Type") FROM "ship" GROUP BY "Type" ORDER BY COUNT("Type") NULLS FIRST