CREATE TABLE university (affiliation VARCHAR2)

Find how many different affiliation types there are.
SELECT COUNT(DISTINCT affiliation) FROM university
SELECT COUNT(DISTINCT "affiliation") FROM "university"