What is the average number of students enrolled per college?
select avg(enr) from college
What are the states that have larger colleges than that?
select distinct state from college where enr > (select avg(enr) from college)
How many of them are there?
select count(distinct state) from college where enr > (select avg(enr) from college)