Schema: CREATE TABLE university (affiliation VARCHAR)
Question: Find how many different affiliation types there are.
SQL: SELECT COUNT(DISTINCT affiliation) FROM university