Task: Text to Code
Input (English): Step 1: find the Major of Student table.
Step 2: find the DName of Department table whose DNO not one of the results of step 1
Output (English): SELECT T1.DName FROM Department AS T1 WHERE T1.DNO NOT IN ( SELECT T2.Major FROM Student AS T2 )