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

Compare the total number of each fate with a bar chart.
SELECT Fate, COUNT(Fate) FROM mission GROUP BY Fate
SELECT "Fate", COUNT("Fate") FROM "mission" GROUP BY "Fate"