What type of game is 'The Vanishing of Eric Calder'?
select gtype from video_games where gname = 'The vanishing of eric Calder'
Give the hours played by Kim Tracy?
select hours_played from student as t1 join plays_games as t2 where lname = 'Kim' and fname = 'Tracy'
Yes
select city_code from student where fname = 'Shiela' and lname = 'Jones'