Who's student id is 1004?
select * from student where stuid = 1004
Who is her advisor?
select advisor from student where stuid = 1004