Show different citizenship of singers and the number of singers of each citizenship.
CREATE TABLE singer (Citizenship VARCHAR)
SELECT Citizenship, COUNT(*) FROM singer GROUP BY Citizenship
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE singer (Citizenship VARCHAR) Question: Show different citizenship of singers and the number of singers of each citizenship. [/INST] SELECT Citizenship, COUNT(*) FROM singer GROUP BY Citizenship </s>