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

Compare the total number of different ranks using a bar graph, and order from high to low by the how many rank.
SELECT Rank, COUNT(Rank) FROM captain GROUP BY Rank ORDER BY COUNT(Rank) DESC
SELECT "Rank", COUNT("Rank") FROM "captain" GROUP BY "Rank" ORDER BY COUNT("Rank") DESC