Table schema:
CREATE TABLE college (state VARCHAR, enr INTEGER)

Question: What is the number of states that has some colleges whose enrollment is smaller than the average enrollment?
SQL: SELECT COUNT(DISTINCT state) FROM college WHERE enr < (SELECT AVG(enr) FROM college)