SELECT StuID FROM Sportsinfo WHERE onscholarship  =  'Y'
List ids for all student who are on scholarship.
SELECT StuID FROM Sportsinfo WHERE onscholarship = 'Y '
select stuid from sportsinfo where onscholarship = value
List ids for all student who are on scholarship .