SELECT flag FROM ship GROUP BY flag ORDER BY count(*) DESC LIMIT 1
Return the flag that is most common among all ships.
SELECT flag FROM ship GROUP BY flag ORDER BY count ( * ) DESC LIMIT 1
select flag from ship group by flag order by count ( * ) desc limit value
Return the flag that is most common among all ships .