What are the ids of all students who are in major 600?
select stuid from student where major = 600
What are the student ids for all those on scholarship?
select stuid from sportsinfo where onscholarship = 'Y'
What ids are in both categories?
select stuid from student where major = 600 intersect select stuid from sportsinfo where onscholarship = 'Y'