Database: club_1
Question: Which clubs have one or more members from the city with code "HOU"? Give me the names of the clubs.
SQL:
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"