How many membership registrations are there in file?
select count(*) from membership_register_branch
Show me the member names and branch names associated with them.
select t3.name, t2.name from membership_register_branch as t1 join branch as t2 on t1.branch_id = t2.branch_id join member as t3 on t1.member_id = t3.member_id
List them in order of their register years.
select t3.name, t2.name from membership_register_branch as t1 join branch as t2 on t1.branch_id = t2.branch_id join member as t3 on t1.member_id = t3.member_id order by t1.register_year