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)

Show me a bar chart comparing the total number of captains in each rank.
SELECT Rank, COUNT(Rank) FROM captain GROUP BY Rank
SELECT "Rank", COUNT("Rank") FROM "captain" GROUP BY "Rank"