CREATE TABLE member (member_id NUMBER, card_number CLOB, name CLOB, hometown CLOB, level NUMBER)
CREATE TABLE branch (branch_id NUMBER, name CLOB, open_year CLOB, address_road CLOB, city CLOB, membership_amount CLOB)
CREATE TABLE purchase (member_id NUMBER, branch_id CLOB, year CLOB, total_pounds NUMBER)
CREATE TABLE membership_register_branch (member_id NUMBER, branch_id CLOB, register_year CLOB)

What are the total purchases for members rated at level 6?
SELECT COUNT(*) FROM purchase AS T1 JOIN member AS T2 ON T1.member_id = T2.member_id WHERE T2.level = 6
SELECT COUNT(*) FROM "purchase" "T1" JOIN "member" "T2" ON "T1"."member_id" = "T2"."member_id" AND "T2"."level" = 6