Database: university_basketball
Question: Find how many different affiliation types there are.
SQL:
SELECT count(DISTINCT affiliation) FROM university