Show ids of students who play video game and play sports.
CREATE TABLE Plays_games (StuID VARCHAR); CREATE TABLE Sportsinfo (StuID VARCHAR)
SELECT StuID FROM Sportsinfo INTERSECT SELECT StuID FROM Plays_games
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Plays_games (StuID VARCHAR); CREATE TABLE Sportsinfo (StuID VARCHAR) Question: Show ids of students who play video game and play sports. [/INST] SELECT StuID FROM Sportsinfo INTERSECT SELECT StuID FROM Plays_games </s>