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

Visualize the proportion of the total number of captains in each rank using a pie chart.
SELECT Rank, COUNT(Rank) FROM captain GROUP BY Rank
SELECT "Rank", COUNT("Rank") FROM "captain" GROUP BY "Rank"