CREATE TABLE Ship (Ship_ID INT, Name TEXT, Type TEXT, Built_Year FLOAT, Class TEXT, Flag TEXT)
CREATE TABLE captain (Captain_ID INT, Name TEXT, Ship_ID INT, age TEXT, Class TEXT, Rank TEXT)

Plot how many class by grouped by class as a bar graph, order in asc by the Class.
SELECT Class, COUNT(Class) FROM captain GROUP BY Class ORDER BY Class
SELECT "Class", COUNT("Class") FROM "captain" GROUP BY "Class" ORDER BY "Class" NULLS FIRST