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)

Count the number of captains that have each rank Visualize by bar chart, and show in desc by the Rank please.
SELECT Rank, COUNT(*) FROM captain GROUP BY Rank ORDER BY Rank DESC
SELECT "Rank", COUNT(*) FROM "captain" GROUP BY "Rank" ORDER BY "Rank" DESC