Tell me the city code of the city where "Davis Steven" lives.
select city_code from student where lname = "Davis" and fname = "Steven"
What is his major?
select major from student where lname = "Davis" and fname = "Steven"
Tell me the clubs having "Davis Steven" as a member.
select distinct t1.clubname from club as t1 join member_of_club as t2 on t1.clubid = t2.clubid join student as t3 on t2.stuid = t3.stuid where t3.fname = "Davis" and t3.lname = "Steven"