Which game names were played by Linda Smith?
select gname from plays_games as t1 join video_games as t2 on t1.gameid = t2.gameid join student as t3 on t3.stuid = t1.stuid where t3.lname = "Smith" and t3.fname = "Linda"
What is the Gtype of RGN Stone?
select gtype from video_games where gname = "RNG Stone"
What is the city code of Student Shiela Jones?
select city_code from student where lname = "Jones" and fname = "Shiela"
How many Hours Played do The Vanishing of Eric Calde hasr?
select t1.hours_played from plays_games as t1 join video_games as t2 on t1.gameid = t2.gameid where gname = "The vanishing of eric Calder"
What are the Student names who have played Gname The Vanishing of Eric Calder.
select t3.fname, t3.lname from plays_games as t1 join video_games as t2 on t1.gameid = t2.gameid join student as t3 on t3.stuid = t1.stuid where t2.gname = "The vanishing of eric Calder"
What is the total Hours Played of all Students?
select sum ( hours_played ) from plays_games