Show different parties of people along with the number of people in each party.
CREATE TABLE people (Party VARCHAR)
SELECT Party, COUNT(*) FROM people GROUP BY Party
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE people (Party VARCHAR) Question: Show different parties of people along with the number of people in each party. [/INST] SELECT Party, COUNT(*) FROM people GROUP BY Party </s>