SELECT TYPE ,  COUNT(*) FROM ship GROUP BY TYPE
For each type, how many ships are there?
SELECT TYPE , COUNT ( * ) FROM ship GROUP BY TYPE
select type , count ( * ) from ship group by type
For each type , how many ships are there ?