Show different types of ships and the number of ships of each type.
select type, count(*) from ship group by type