What are the last names for those students?
SELECT T2.Lname FROM Sportsinfo AS T1 JOIN Student AS T2 ON T1.StuID   =   T2.StuID WHERE T1.onscholarship   =   'Y'
last names for students refers to Lname from Student; students on scholarship refers to onscholarship = 'Y'; joining condition is based on StuID matching between Sportsinfo and Student tables;