CREATE TABLE Sportsinfo (StuID VARCHAR, major VARCHAR, onscholarship VARCHAR)
CREATE TABLE Student (StuID VARCHAR, major VARCHAR, onscholarship VARCHAR)

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'
SELECT "StuID" FROM "Student" WHERE "major" = 600 INTERSECT SELECT "StuID" FROM "Sportsinfo" WHERE "onscholarship" = 'Y'