Task: Text to Code
Input (English): find the Advisor of Student table for which Major equals 1004
Output (English): SELECT Advisor FROM Student WHERE Major = 1004