Database: shop_membership
Question: How many branches where have more than average number of memberships are there?
SQL:
SELECT count(*) FROM branch WHERE membership_amount  >  (SELECT avg(membership_amount) FROM branch)