For each type, how many ships are there?
SELECT TYPE ,  COUNT(*) FROM ship GROUP BY TYPE
SELECT TYPE ,  COUNT(*) FROM ship GROUP BY TYPE
[{'Type': 'Battle ship', 'COUNT(*)': 3}, {'Type': 'Cargo ship', 'COUNT(*)': 5}]