What are the ids of all students who played football or Lacrosse?
select stuid from sportsinfo where sportname = "Football" or sportname = "Lacrosse"
What are the first names that correspond to those ids?
select t2.fname from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.sportname = "Football" or t1.sportname = "Lacrosse"
Also, what are their last names?
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"