Hello!  Can you provide me with a list of all of the colleges located in the state of LA?
select cname from college where state = "LA"
Awesome! Can you show me a list that contains both the colleges in LA and those located in AZ?
select cname from college where state = "LA" or state = "AZ"
Sure!  What is the average enrollment of ASU and LSU?
select avg ( enr ) from college where cname = "ASU" or cname = "LSU"