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)

Give me a pie to show the total number from different flag.
SELECT Flag, COUNT(*) FROM Ship GROUP BY Flag
SELECT "Flag", COUNT(*) FROM "Ship" GROUP BY "Flag"