Show student ids who are on scholarship and have major 600.
CREATE TABLE Sportsinfo (
    StuID VARCHAR,
    major VARCHAR,
    onscholarship VARCHAR
)

CREATE TABLE Student (
    StuID VARCHAR,
    major VARCHAR,
    onscholarship VARCHAR
)
SELECT StuID FROM Student WHERE major = 600 INTERSECT SELECT StuID FROM Sportsinfo WHERE onscholarship = 'Y'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show student ids who are on scholarship and have major 600. ### Input: CREATE TABLE Sportsinfo (
    StuID VARCHAR,
    major VARCHAR,
    onscholarship VARCHAR
)

CREATE TABLE Student (
    StuID VARCHAR,
    major VARCHAR,
    onscholarship VARCHAR
) ### Response: SELECT StuID FROM Student WHERE major = 600 INTERSECT SELECT StuID FROM Sportsinfo WHERE onscholarship = 'Y'