Task: Text to Code
Input (English): Step 1: find the DName of Department table for which Division equals AS.
Step 2: find DName of Department table whose Division equals EN and Building equals NEB.
Step 3: show the rows that are in both the results of step 1 and the results of step 2
Output (English): SELECT DName FROM Department WHERE Division = "AS" INTERSECT SELECT DName FROM Department WHERE Division = "EN" AND Building = "NEB"