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)

Return a bar chart on what are the different ship flags, and how many ships have each?, list by the Y-axis in descending.
SELECT Flag, COUNT(*) FROM Ship GROUP BY Flag ORDER BY COUNT(*) DESC
SELECT "Flag", COUNT(*) FROM "Ship" GROUP BY "Flag" ORDER BY COUNT(*) DESC NULLS LAST