Database: ship_mission
Question: For each type, how many ships are there?
SQL:
SELECT TYPE ,  COUNT(*) FROM ship GROUP BY TYPE