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)

A stacked bar chart shows the total number of ships with different nationalities and split by ship type, I want to sort Y-axis in desc order.
SELECT Nationality, COUNT(Nationality) FROM ship GROUP BY Type, Nationality ORDER BY COUNT(Nationality) DESC
SELECT "Nationality", COUNT("Nationality") FROM "ship" GROUP BY "Type", "Nationality" ORDER BY COUNT("Nationality") DESC