Show last names for all student who are on scholarship.
create table student (lname varchar, stuid varchar, PRIMARY KEY (lname)); create table sportsinfo (stuid varchar, onscholarship varchar, PRIMARY KEY (stuid))
select t2.lname from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.onscholarship = 'y'