Database: soccer_2
Question: What is the number of states that has some college whose enrollment is larger than the average enrollment?
SQL:
SELECT count(DISTINCT state) FROM college WHERE enr  >  (SELECT avg(enr) FROM college)