For each type, how many ships are there?
select type, count(*) from ship group by type