CREATE TABLE branch (name VARCHAR2, branch_id VARCHAR2)
CREATE TABLE membership_register_branch (branch_id VARCHAR2, register_year NUMBER)

Show all branch names with the number of members in each branch registered after 2015.
SELECT T2.name, COUNT(*) FROM membership_register_branch AS T1 JOIN branch AS T2 ON T1.branch_id = T2.branch_id WHERE T1.register_year > 2015 GROUP BY T2.branch_id
SELECT "T2"."name", COUNT(*) FROM "membership_register_branch" "T1" JOIN "branch" "T2" ON "T1"."branch_id" = "T2"."branch_id" WHERE "T1"."register_year" > 2015 GROUP BY "T2"."branch_id"