CREATE TABLE member (member_id VARCHAR(255), level VARCHAR(255)); CREATE TABLE purchase (member_id VARCHAR(255))
What is the total number of purchases for members with level 6?
    
SQL: SELECT COUNT(*) FROM purchase AS T1 JOIN member AS T2 ON T1.member_id = T2.member_id WHERE T2.level = 6