Database: singer
Question: For each citizenship, how many singers are from that country?
SQL:
SELECT Citizenship ,  COUNT(*) FROM singer GROUP BY Citizenship