CREATE TABLE ship (flag VARCHAR(255))
Group by ships by flag, and return number of ships that have each flag.
    
SQL: SELECT COUNT(*), flag FROM ship GROUP BY flag