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

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" "T1" JOIN "student" "T2" ON "T1"."stuid" = "T2"."stuid" WHERE "T1"."onscholarship" = 'Y'