Find the names of either colleges in LA with greater than 15000 size or in state AZ with less than 13000 enrollment.
select cname from college where enr < 13000 and state = "AZ" union select cname from college where enr > 15000 and state = "LA"
OK! please give me the names of the colleges where enrollment is greater than 20000
select cname from college where enr>20000
Also give me the names of the colleges where enrollment is between 10000 and 20000.
select cname from college where enr<20000 and enr>10000
Ok. Can you please tell me which college has the lowest enrollment.
select cname from college order by enr limit 1
And which college has the highest enrollment?
select cname from college order by enr desc limit 1