list the name of college in az?
select cname from college where state = 'AZ'
list the name of the colleges whose enrollment is lesser than 18000 sorted by the college's name?
select cname from college where enr > 18000 order by cname
which college enrollment is 22000?
select cname from college where enr = 22000
list the name of the colleges whose enrollment is greater than 12000 sorted by the college's name and state?
select cname from college where enr > 12000 order by cname, state