CREATE TABLE plays_games (stuid DECIMAL, gameid DECIMAL, hours_played DECIMAL)
CREATE TABLE sportsinfo (stuid DECIMAL, sportname TEXT, hoursperweek DECIMAL, gamesplayed DECIMAL, onscholarship TEXT)
CREATE TABLE video_games (gameid DECIMAL, gname TEXT, gtype TEXT)
CREATE TABLE student (stuid DECIMAL, lname TEXT, fname TEXT, age DECIMAL, sex TEXT, major DECIMAL, advisor DECIMAL, city_code TEXT)

List ids for all student who are on scholarship.
SELECT stuid FROM sportsinfo WHERE onscholarship = 'Y'
SELECT "stuid" FROM "sportsinfo" WHERE "onscholarship" = 'Y'