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

What is the total number of different nationalities of all ships? Give me a bar graph, and I want to list by the Y from low to high.
SELECT Nationality, COUNT(Nationality) FROM ship GROUP BY Nationality ORDER BY COUNT(Nationality)
SELECT "Nationality", COUNT("Nationality") FROM "ship" GROUP BY "Nationality" ORDER BY COUNT("Nationality")