Database: soccer_2
Question: How many states have smaller colleges than average?
SQL:
SELECT count(DISTINCT state) FROM college WHERE enr  <  (SELECT avg(enr) FROM college)