SELECT StuID FROM Sportsinfo WHERE onscholarship  =  'Y'
What are the ids for all sporty students who are on scholarship?
SELECT StuID FROM Sportsinfo WHERE onscholarship = 'Y '
select stuid from sportsinfo where onscholarship = value
What are the ids for all sporty students who are on scholarship ?