SELECT count(*) ,  affiliation FROM university WHERE enrollment  >  20000 GROUP BY affiliation
What are the different affiliations, and how many schools with each have an enrollment size of above 20000?
SELECT count ( * ) , affiliation FROM university WHERE enrollment > 20000 GROUP BY affiliation
select count ( * ) , affiliation from university where enrollment > value group by affiliation
What are the different affiliations , and how many schools with each have an enrollment size of above 20000 ?