CREATE TABLE mission (mission_id DECIMAL, ship_id DECIMAL, code TEXT, launched_year DECIMAL, location TEXT, speed_knots DECIMAL, fate TEXT)
CREATE TABLE ship (ship_id DECIMAL, name TEXT, type TEXT, nationality TEXT, tonnage DECIMAL)

For each type, how many ships are there?
SELECT type, COUNT(*) FROM ship GROUP BY type
SELECT "type", COUNT(*) FROM "ship" GROUP BY "type"