CREATE TABLE member_of_club (clubid VARCHAR(255), stuid VARCHAR(255)); CREATE TABLE club (clubname VARCHAR(255), clubid VARCHAR(255)); CREATE TABLE student (stuid VARCHAR(255), city_code VARCHAR(255))
Find the names of the clubs that have at least a member from the city with city code "HOU".
    
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"