CREATE TABLE branch (membership_amount INT)

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")