CREATE TABLE membership_register_branch (name VARCHAR2, city VARCHAR2, branch_id VARCHAR2)
CREATE TABLE branch (name VARCHAR2, city VARCHAR2, branch_id VARCHAR2)

List the branch name and city without any registered members.
SELECT name, city FROM branch WHERE NOT branch_id IN (SELECT branch_id FROM membership_register_branch)
SELECT "name", "city" FROM "branch" WHERE NOT "branch_id" IN (SELECT "branch_id" FROM "membership_register_branch")