What are the enrollments of all colleges in the state of FL?
select sum ( enr ) from college where state = 'FL'
What are the names of all colleges that have an enrollment greater than at least one of the colleges in FL?
select distinct cname from college where enr > ( select min ( enr ) from college where state = 'FL' )
What are the names of all colleges that have an enrollment greater than at least one of the colleges in OK?
select distinct cname from college where enr > ( select min ( enr ) from college where state = 'OK' )
How about the names of all colleges that have an enrollment less than at least one of the colleges in OK?
select distinct cname from college where enr < ( select max ( enr ) from college where state = 'OK' )
What are the names of all colleges that have an enrollment less than at least one of the colleges in FL?
select distinct cname from college where enr < ( select max ( enr ) from college where state = 'FL' )