SELECT T2.Lname FROM Sportsinfo AS T1 JOIN Student AS T2 ON T1.StuID  =  T2.StuID WHERE T1.onscholarship  =  'Y'
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 as t1 join student as t2 on t1 . stuid = t2 . stuid where t1 . onscholarship = value
What are the last names for all scholarship students ?