CREATE TABLE member (member_id NUMBER, member_name CLOB, party_id CLOB, in_office CLOB)
CREATE TABLE party_events (event_id NUMBER, event_name CLOB, party_id NUMBER, member_in_charge_id NUMBER)
CREATE TABLE party (party_id NUMBER, minister CLOB, took_office CLOB, left_office CLOB, region_id NUMBER, party_name CLOB)
CREATE TABLE region (region_id NUMBER, region_name CLOB, date CLOB, label CLOB, format CLOB, catalogue CLOB)

Show all member names who are not in charge of any event.
SELECT member_name FROM member EXCEPT SELECT T1.member_name FROM member AS T1 JOIN party_events AS T2 ON T1.member_id = T2.member_in_charge_id
SELECT "member_name" FROM "member" EXCEPT SELECT "T1"."member_name" FROM "member" "T1" JOIN "party_events" "T2" ON "T1"."member_id" = "T2"."member_in_charge_id"