What information you have on colleges that have more than 10000 students enrolled?
select * from college where enr > 10000
Of those, which refer to colleges in the state of LA?
select * from college where enr > 10000 and state = "LA"
What are these colleges' names and enrollment numbers?
select cname, enr from college where enr > 10000 and state = "LA"