What are the First names of students living in smith hall?
select t1.fname from student as t1 join lives_in as t2 on t1.stuid = t2.stuid join dorm as t3 on t3.dormid = t2.dormid where t3.dorm_name = 'Smith Hall'
Yes
select lname from student where fname = "Tracy"
What is the city code of student Tracy kim?
select city_code from student where fname = "Tracy" and lname = "Kim"
What is the Student capacity of Smith Hall?
select student_capacity from dorm where dorm_name = "Smith Hall"