CREATE TABLE Sportsinfo (StuID VARCHAR2, onscholarship VARCHAR2)
CREATE TABLE Student (Lname VARCHAR2, StuID VARCHAR2)

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'