CREATE TABLE DEPARTMENT (DName VARCHAR2, Division VARCHAR2, Building VARCHAR2)

Find the names of departments that are either in division AS or in division EN and in Building NEB.
SELECT DName FROM DEPARTMENT WHERE Division = "AS" UNION SELECT DName FROM DEPARTMENT WHERE Division = "EN" AND Building = "NEB"
SELECT "DName" FROM "DEPARTMENT" WHERE "AS" = "Division" UNION SELECT "DName" FROM "DEPARTMENT" WHERE "Building" = "NEB" AND "Division" = "EN"