Can you list all the colleges and their enrollments?
select cname, enr from college
Which college has the largest enrollment?
select cname from college where enr = ( select max ( enr ) from college )
Hmm, I also want to know which colleges have enrollments that are less than the largest size.
select cname from college where enr < ( select max ( enr ) from college )
Can you list the states of those colleges?
select cname, state from college where enr < ( select max ( enr ) from college )