What are different nationalities of people and the corresponding number of people from each nation?
CREATE TABLE people (Nationality VARCHAR)
SELECT Nationality, COUNT(*) FROM people GROUP BY Nationality
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE people (Nationality VARCHAR) Question: What are different nationalities of people and the corresponding number of people from each nation? [/INST] SELECT Nationality, COUNT(*) FROM people GROUP BY Nationality </s>