SCHEMA:
CREATE TABLE ship (TYPE VARCHAR)
USER:
Show different types of ships and the number of ships of each type.

QUERY:
SELECT TYPE, COUNT(*) FROM ship GROUP BY TYPE