How many students are there living in NYC?
select count(*) from student where city_code = "NYC"
Tell me the clubs they are in.
select 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.city_code = "NYC"
Tell me how many members of "Bootup Baltimore" are older than 18?
select count(*) 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 t1.clubname = "Bootup Baltimore" and t3.age > 18