Find the last and first name of students who are playing Football or Lacrosse.
create table sportsinfo (stuid varchar, sportname varchar, PRIMARY KEY (stuid)); create table student (lname varchar, fname varchar, stuid varchar, PRIMARY KEY (lname))
select t2.lname, t2.fname from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.sportname = "football" or t1.sportname = "lacrosse"