CREATE TABLE member (member_id NUMBER, card_number CLOB, name CLOB, hometown CLOB, level NUMBER)
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)
CREATE TABLE branch (branch_id NUMBER, name CLOB, open_year CLOB, address_road CLOB, city CLOB, membership_amount CLOB)

What is the number of branches that have more than the average number of memberships?
SELECT COUNT(*) FROM branch WHERE membership_amount > (SELECT AVG(membership_amount) FROM branch)
SELECT COUNT(*) FROM "branch" WHERE "membership_amount" > (SELECT AVG("membership_amount") FROM "branch")