CREATE TABLE club (clubid DECIMAL, clubname TEXT, clubdesc TEXT, clublocation TEXT)
CREATE TABLE member_of_club (stuid DECIMAL, clubid DECIMAL, position TEXT)
CREATE TABLE student (stuid DECIMAL, lname TEXT, fname TEXT, age DECIMAL, sex TEXT, major DECIMAL, advisor DECIMAL, city_code TEXT)

How many clubs does 'Linda Smith' have membership for?
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 = "Linda" AND t3.lname = "Smith"
SELECT COUNT(*) FROM "club" AS "t1" JOIN "member_of_club" AS "t2" ON "t1"."clubid" = "t2"."clubid" JOIN "student" AS "t3" ON "Linda" = "t3"."fname" AND "Smith" = "t3"."lname" AND "t2"."stuid" = "t3"."stuid"