SELECT count(DISTINCT state) FROM college WHERE enr  >  (SELECT avg(enr) FROM college)
How many states have a college with more students than average?
SELECT count ( DISTINCT state ) FROM college WHERE enr > ( SELECT avg ( enr ) FROM college )
select count ( distinct state ) from college where enr > ( select avg ( enr ) from college )
How many states have a college with more students than average ?