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

Show last names for all student who are on scholarship.
SELECT T2.lname FROM sportsinfo AS T1 JOIN student AS T2 ON T1.stuid = T2.stuid WHERE T1.onscholarship = 'Y'
SELECT "T2"."lname" FROM "sportsinfo" AS "T1" JOIN "student" AS "T2" ON "T1"."stuid" = "T2"."stuid" WHERE "T1"."onscholarship" = 'Y'