SELECT TYPE ,  COUNT(*) FROM ship GROUP BY TYPE
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
Show different types of ships and the number of ships of each type .