Show member names with a registered branch?
select name from member where member_id in ( select member_id from membership_register_branch )
Show member names without any registered branch?
select name from member where member_id not in ( select member_id from membership_register_branch )
What is the total number of branches?
select count ( distinct branch_id ) from membership_register_branch