SELECT name ,  city FROM branch WHERE branch_id NOT IN (SELECT branch_id FROM membership_register_branch)
What are the names and cities of the branches that do not have any registered members?
SELECT name , city FROM branch WHERE branch_id NOT IN ( SELECT branch_id FROM membership_register_branch )
select name , city from branch where branch_id not in ( select branch_id from membership_register_branch )
What are the names and cities of the branches that do not have any registered members ?