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)

What is the total number of each fate? Give me the result in a bar graph, and display in desc by the the number of fate please.
SELECT Fate, COUNT(Fate) FROM mission GROUP BY Fate ORDER BY COUNT(Fate) DESC
SELECT "Fate", COUNT("Fate") FROM "mission" GROUP BY "Fate" ORDER BY COUNT("Fate") DESC