CREATE TABLE plays_games (stuid DECIMAL, gameid DECIMAL, hours_played DECIMAL)
CREATE TABLE sportsinfo (stuid DECIMAL, sportname TEXT, hoursperweek DECIMAL, gamesplayed DECIMAL, onscholarship TEXT)
CREATE TABLE student (stuid DECIMAL, lname TEXT, fname TEXT, age DECIMAL, sex TEXT, major DECIMAL, advisor DECIMAL, city_code TEXT)
CREATE TABLE video_games (gameid DECIMAL, gname TEXT, gtype TEXT)

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" AS "T1" JOIN "student" AS "T2" ON "T1"."stuid" = "T2"."stuid" WHERE "Football" = "T1"."sportname" OR "Lacrosse" = "T1"."sportname"