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

Find the first name and age of the students who are playing both Football and Lacrosse.
SELECT fname, age FROM student WHERE stuid IN (SELECT stuid FROM sportsinfo WHERE sportname = "Football" INTERSECT SELECT stuid FROM sportsinfo WHERE sportname = "Lacrosse")
SELECT "fname", "age" FROM "student" WHERE "stuid" IN (SELECT "stuid" FROM "sportsinfo" WHERE "Football" = "sportname" INTERSECT SELECT "stuid" FROM "sportsinfo" WHERE "Lacrosse" = "sportname")