Task: Text to Code
Input (English): Who advises student 1004?
Output (English): SELECT Advisor FROM Student WHERE StuID  =  1004