Database: university_basketball
Question: Find the number of universities that have over a 20000 enrollment size for each affiliation type.
SQL:
SELECT count(*) ,  affiliation FROM university WHERE enrollment  >  20000 GROUP BY affiliation