How many distinct parties are there for representatives?
CREATE TABLE representative (Party VARCHAR)
SELECT COUNT(DISTINCT Party) FROM representative
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE representative (Party VARCHAR) Question: How many distinct parties are there for representatives? [/INST] SELECT COUNT(DISTINCT Party) FROM representative </s>