What is the average enrollment?
select avg ( enr ) from college
Please list the states where LSU, OU, and FSU are located.
select distinct state from college where enr > ( select avg ( enr ) from college )
How many total states are in the table?
select count ( distinct state ) from college where enr > ( select avg ( enr ) from college )