CREATE TABLE ship (Ship_ID NUMBER, Name CLOB, Type CLOB, Nationality CLOB, Tonnage NUMBER)
CREATE TABLE mission (Mission_ID NUMBER, Ship_ID NUMBER, Code CLOB, Launched_Year NUMBER, Location CLOB, Speed_knots NUMBER, Fate CLOB)

Show different types of ships and the number of ships of each type Show bar chart, display in ascending by the the total number .
SELECT Type, COUNT(*) FROM ship GROUP BY Type ORDER BY COUNT(*)
SELECT "Type", COUNT(*) FROM "ship" GROUP BY "Type" ORDER BY COUNT(*)