Database: shop_membership
Question: 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