Schema: CREATE TABLE university (affiliation VARCHAR, enrollment INTEGER)
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