CREATE TABLE member_of_club (clubid VARCHAR2, stuid VARCHAR2)
CREATE TABLE student (stuid VARCHAR2, fname VARCHAR2, lname VARCHAR2)
CREATE TABLE club (clubname VARCHAR2, clubid VARCHAR2)

How many clubs does the student named 'Eric Tai' belong to?
SELECT COUNT(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.fname = "Eric" AND t3.lname = "Tai"
SELECT COUNT(DISTINCT "t1"."clubname") FROM "club" "t1" JOIN "member_of_club" "t2" ON "t1"."clubid" = "t2"."clubid" JOIN "student" "t3" ON "Eric" = "t3"."fname" AND "Tai" = "t3"."lname" AND "t2"."stuid" = "t3"."stuid"