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)

Compare the total number of each fate with a bar chart, list X-axis in asc order.
SELECT Fate, COUNT(Fate) FROM mission GROUP BY Fate ORDER BY Fate
SELECT "Fate", COUNT("Fate") FROM "mission" GROUP BY "Fate" ORDER BY "Fate"