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