SELECT TYPE FROM ship GROUP BY TYPE ORDER BY COUNT(*) DESC LIMIT 1
What is 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
What is the most common type of ships ?