Show student ids who are on scholarship and have major 600.
select stuid from student where major = 600 intersect select stuid from sportsinfo where onscholarship = 'Y'