Show different types of ships and the number of ships of each type.
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}]