What are the department names for departments in division AS?
select dname from department where division = "AS"
What are department names for departments in divison EN and building NEB?
select dname from department where division = "EN" and building = "NEB"
What are the names for departments in either group?
select dname from department where division = "AS" union select dname from department where division = "EN" and building = "NEB"