Who is the advisor of student with ID 1004?
select advisor from student where stuid = 1004