Database: shop_membership
Question: What are the total purchases for members rated at level 6?
SQL:
SELECT count(*) FROM purchase AS T1 JOIN member AS T2 ON T1.member_id  =  T2.member_id WHERE T2.level  =  6