CREATE TABLE SportsInfo (StuID VARCHAR(255), SportName VARCHAR(255)); CREATE TABLE Student (lname VARCHAR(255), fname VARCHAR(255), StuID VARCHAR(255))
Find the last and first name of students who are playing Football or Lacrosse.
    
SQL: 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"