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

How many branches where have more than average number of memberships are there?
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")