What is the total number of purchases for members with level 6?
CREATE TABLE purchase (
    member_id VARCHAR
)

CREATE TABLE member (
    member_id VARCHAR,
    level VARCHAR
)
SELECT COUNT(*) FROM purchase AS T1 JOIN member AS T2 ON T1.member_id = T2.member_id WHERE T2.level = 6
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: What is the total number of purchases for members with level 6? ### Input: CREATE TABLE purchase (
    member_id VARCHAR
)

CREATE TABLE member (
    member_id VARCHAR,
    level VARCHAR
) ### Response: SELECT COUNT(*) FROM purchase AS T1 JOIN member AS T2 ON T1.member_id = T2.member_id WHERE T2.level = 6