Database: allergy_1
Question: Who is the advisor of student with ID 1004?
SQL:
SELECT Advisor FROM Student WHERE StuID  =  1004