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