What is the number of students enrolled in each college?
select cname, enr from college
Of those, which refer to students enrolled in places in Florida?
select cname, enr from college where state = 'FL'
What is the average number enrolled for them?
select avg(enr) from college where state = 'FL'