Which flags are used?
select distinct flag from ship
Which is most common?
select flag from ship group by flag order by count(*) desc limit 1