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