What are the different affiliation types of these schools?
select distinct affiliation from university
Which universities have over a 20000 enrollment size?
select school from university where enrollment > 20000
Can you also list their affiliation type?
select school, affiliation from university where enrollment > 20000
How many are there in each affiliation group?
select count(*), affiliation from university where enrollment > 20000 group by affiliation