Tell me the location of the club "Bootup Baltimore".
select clublocation from club where clubname = "Bootup Baltimore"
Tell me the city code of the cities where at least a member of that club live in.
select t3.city_code 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"
What are the names of the clubs that have at least a member from the city with the city code "HOU"?
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.city_code = "HOU"