What are the different ship flags, and how many ships have each?
SELECT count(*) ,  flag FROM ship GROUP BY flag
SELECT count(*) ,  flag FROM ship GROUP BY flag
[{'count(*)': 1, 'Flag': 'Malta'}, {'count(*)': 8, 'Flag': 'Panama'}]