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)

What are the different ship flags, and how many ships have each Plot them as bar chart, rank Y-axis in descending order.
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