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

What are the last names for all scholarship students?
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" "T1" JOIN "student" "T2" ON "T1"."stuid" = "T2"."stuid" WHERE "T1"."onscholarship" = 'Y'