Database: singer
Question: Show different citizenship of singers and the number of singers of each citizenship.
SQL:
SELECT Citizenship ,  COUNT(*) FROM singer GROUP BY Citizenship