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

Draw a bar chart for what are the different ship flags, and how many ships have each?, and 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