How many colleges have enrollment greater than 18000?
select count ( * ) from college where enr > 18000
What are their names?
select cname from college where enr > 18000
What is the enrollment for OU?
select enr from college where cname = 'OU'
Yes I would.
select enr from college where cname = 'LSU'
In which state is LSU located?
select state from college where cname = 'LSU'
And the state for OU?
select state from college where cname = 'OU'