CREATE TABLE Student (lname VARCHAR2, fname VARCHAR2, StuID VARCHAR2)
CREATE TABLE SportsInfo (StuID VARCHAR2, SportName VARCHAR2)

Find the last and first name of students who are playing Football or Lacrosse.
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"
SELECT "T2"."lname", "T2"."fname" FROM "SportsInfo" "T1" JOIN "Student" "T2" ON "T1"."StuID" = "T2"."StuID" WHERE "Football" = "T1"."SportName" OR "Lacrosse" = "T1"."SportName"