ค้นหานามสกุลและเพศของนักเรียนที่กำลังเล่นเกม Call of Destiny และ Works of Widenius ไม่จำเป็นต้องใช้ตารางทั้งหมด
Find the last name and gender of the students who are playing both Call of Destiny and Works of Widenius games.It is not neccessary to use all the tables.
 Plays_games:  (StuID [ VARCHAR ] GameID [ VARCHAR) ]
SELECT lname, sex FROM Student WHERE StuID IN (SELECT T1.StuID FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.GameID = T2.GameID WHERE T2.Gname = "Call of Destiny" INTERSECT SELECT T1.StuID FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.GameID = T2.GameID WHERE T2.Gname = "Works of Widenius")