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

Count the number of captains that have each rank by a bar chart.
SELECT Rank, COUNT(*) FROM captain GROUP BY Rank
SELECT "Rank", COUNT(*) FROM "captain" GROUP BY "Rank"