What are the types of ships?
select type from ship
Which type is the most common?
select type from ship group by type order by count(*) desc limit 1