How many membership registrations are there in file?
select count(*) from membership_register_branch
Show me the id of members in any of them.
select member_id from membership_register_branch
Give me the name of members who are not one of those.
select name from member where member_id not in (select member_id from membership_register_branch)