Task: Text to Code
Input (English): Step 1: find without repetition the LName of Student table.
Step 2: find the LName of Student table for which Advisor equals 2192.
Step 3: show the rows that are in the results of step 1 but not in the results of step 2
Output (English): SELECT DISTINCT LName FROM Student EXCEPT SELECT LName FROM Student WHERE Advisor = 2192