Database: shop_membership
Question: List the branch name and city without any registered members.
SQL:
SELECT name ,  city FROM branch WHERE branch_id NOT IN (SELECT branch_id FROM membership_register_branch)