CREATE TABLE mission (Mission_ID NUMBER, Ship_ID NUMBER, Code CLOB, Launched_Year NUMBER, Location CLOB, Speed_knots NUMBER, Fate CLOB)
CREATE TABLE ship (Ship_ID NUMBER, Name CLOB, Type CLOB, Nationality CLOB, Tonnage NUMBER)

Draw a bar chart showing the total number of every ship type by categorizing by nationality, and I want to rank by the Y-axis in desc.
SELECT Type, COUNT(Type) FROM ship GROUP BY Nationality, Type ORDER BY COUNT(Type) DESC
SELECT "Type", COUNT("Type") FROM "ship" GROUP BY "Nationality", "Type" ORDER BY COUNT("Type") DESC