Show different citizenships and the maximum net worth of singers of each citizenship.
CREATE TABLE singer (Citizenship VARCHAR, Net_Worth_Millions INTEGER)
SELECT Citizenship, MAX(Net_Worth_Millions) 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, Net_Worth_Millions INTEGER) Question: Show different citizenships and the maximum net worth of singers of each citizenship. [/INST] SELECT Citizenship, MAX(Net_Worth_Millions) FROM singer GROUP BY Citizenship </s>