Which students play video games?
select distinct stuid from plays_games
How about students who play sports?
select distinct stuid from sportsinfo
Show ids of students who play video games and sports?
select stuid from sportsinfo intersect select stuid from plays_games