List ids for all student who are on scholarship.
CREATE TABLE Sportsinfo (StuID VARCHAR, onscholarship VARCHAR)
SELECT StuID FROM Sportsinfo WHERE onscholarship = 'Y'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Sportsinfo (StuID VARCHAR, onscholarship VARCHAR) Question: List ids for all student who are on scholarship. [/INST] SELECT StuID FROM Sportsinfo WHERE onscholarship = 'Y' </s>