Who advises student 1004?
select advisor from student where stuid = 1004