Find how many different affiliation types there are.
CREATE TABLE university (affiliation VARCHAR)
SELECT COUNT(DISTINCT affiliation) FROM university
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE university (affiliation VARCHAR) Question: Find how many different affiliation types there are. [/INST] SELECT COUNT(DISTINCT affiliation) FROM university </s>