Database: ship_1
Question: Group by ships by flag, and return number of ships that have each flag.
SQL:
SELECT count(*) ,  flag FROM ship GROUP BY flag