Database: shop_membership
Question: What is the number of branches that have more than the average number of memberships?
SQL:
SELECT count(*) FROM branch WHERE membership_amount  >  (SELECT avg(membership_amount) FROM branch)