SELECT count(DISTINCT state) FROM college WHERE enr  <  (SELECT avg(enr) FROM college)
What is the number of states that has some colleges whose enrollment is smaller than the average enrollment?
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 )
What is the number of states that has some colleges whose enrollment is smaller than the average enrollment ?