Quantas filiais têm mais do que o número médio de membros?
CREATE TABLE branch (membership_amount INTEGER)
SELECT COUNT(*) FROM branch WHERE membership_amount > (SELECT AVG(membership_amount) FROM branch)