CREATE TABLE member (member_id CLOB, name CLOB, nationality CLOB, role CLOB)
CREATE TABLE performance (performance_id NUMBER, date CLOB, host CLOB, location CLOB, attendance NUMBER)
CREATE TABLE member_attendance (member_id NUMBER, performance_id NUMBER, num_of_pieces NUMBER)

List the names of members who did not attend any performance.
SELECT name FROM member WHERE NOT member_id IN (SELECT member_id FROM member_attendance)
SELECT "name" FROM "member" WHERE NOT "member_id" IN (SELECT "member_id" FROM "member_attendance")