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)

For each type, how many ships are there Plot them as bar chart, list y-axis in asc order.
SELECT Type, COUNT(*) FROM ship GROUP BY Type ORDER BY COUNT(*)
SELECT "Type", COUNT(*) FROM "ship" GROUP BY "Type" ORDER BY COUNT(*) NULLS FIRST