SELECT count(*) ,  affiliation FROM university WHERE enrollment  >  20000 GROUP BY affiliation
Find the number of universities that have over a 20000 enrollment size for each affiliation type.
SELECT count ( * ) , affiliation FROM university WHERE enrollment > 20000 GROUP BY affiliation
select count ( * ) , affiliation from university where enrollment > value group by affiliation
Find the number of universities that have over a 20000 enrollment size for each affiliation type .