What information do you have on the students?
select * from student
What are their ids?
select stuid from student
Which of those are for students who have advisor 1121?
select stuid from student where advisor = 1121