How many clubs does 'Linda Smith' belong to?
CREATE TABLE student (
    stuid VARCHAR,
    fname VARCHAR,
    lname VARCHAR
)

CREATE TABLE club (
    clubid VARCHAR
)

CREATE TABLE member_of_club (
    clubid VARCHAR,
    stuid VARCHAR
)
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"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many clubs does 'Linda Smith' belong to? ### Input: CREATE TABLE student (
    stuid VARCHAR,
    fname VARCHAR,
    lname VARCHAR
)

CREATE TABLE club (
    clubid VARCHAR
)

CREATE TABLE member_of_club (
    clubid VARCHAR,
    stuid VARCHAR
) ### Response: 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"