Database: ship_1
Question: What are the different ship flags, and how many ships have each?
SQL:
SELECT count(*) ,  flag FROM ship GROUP BY flag