How many branches where have more than average number of memberships are there?
CREATE TABLE branch (membership_amount INTEGER)
SELECT COUNT(*) FROM branch WHERE membership_amount > (SELECT AVG(membership_amount) FROM branch)
### Context: CREATE TABLE branch (membership_amount INTEGER) ### Question: How many branches where have more than average number of memberships are there? ### Answer: SELECT COUNT(*) FROM branch WHERE membership_amount > (SELECT AVG(membership_amount) FROM branch)