What is the name of the college whos size is bigger than 10000?
select cname from college where enr > 10000
Which of those colleges are located in LA?
select * from college where enr > 10000 and state = "LA"
What is the enrollment of that college?
select enr from college where enr > 10000 and state = "LA"