SELECT TYPE FROM ship GROUP BY TYPE ORDER BY COUNT(*) DESC LIMIT 1
Please show the most common type of ships.
SELECT TYPE FROM ship GROUP BY TYPE ORDER BY COUNT ( * ) DESC LIMIT 1
select type from ship group by type order by count ( * ) desc limit value
Please show the most common type of ships .