CREATE TABLE student (stuid VARCHAR(255), fname VARCHAR(255), lname VARCHAR(255)); CREATE TABLE member_of_club (clubid VARCHAR(255), stuid VARCHAR(255)); CREATE TABLE club (clubid VARCHAR(255))
Find the number of clubs where "Tracy Kim" is a member.
    
SQL: 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 t3.fname = "Tracy" AND t3.lname = "Kim"