CREATE TABLE membership_register_branch (member_id NUMBER, branch_id CLOB, register_year CLOB)
CREATE TABLE purchase (member_id NUMBER, branch_id CLOB, year CLOB, total_pounds NUMBER)
CREATE TABLE branch (branch_id NUMBER, name CLOB, open_year CLOB, address_road CLOB, city CLOB, membership_amount CLOB)
CREATE TABLE member (member_id NUMBER, card_number CLOB, name CLOB, hometown CLOB, level NUMBER)

What are the names of the members that have never registered at any branch?
SELECT name FROM member WHERE NOT member_id IN (SELECT member_id FROM membership_register_branch)
SELECT "name" FROM "member" WHERE NOT "member_id" IN (SELECT "member_id" FROM "membership_register_branch")