SELECT flag FROM ship GROUP BY flag ORDER BY count(*) DESC LIMIT 1
Which flag is most widely used 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
Which flag is most widely used among all ships ?