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)
CREATE TABLE member (member_id CLOB, name CLOB, nationality CLOB, role CLOB)

What is the date of the performance with the highest number of attendees?
SELECT date FROM performance ORDER BY attendance DESC LIMIT 1
SELECT "date" FROM "performance" ORDER BY "attendance" DESC FETCH FIRST 1 ROWS ONLY