human
Schema:
member (Member_ID, Name, Nationality, Role)
performance (Performance_ID, Date, Host, Location, Attendance)
member_attendance (Member_ID, Performance_ID, Num_of_Pieces)
Please answer with SQL.
assistant
Sure, I understand.
human
list all dates available
assistant
SELECT Date FROM performance;
human
on what date of the performance with the highest number of attendees?
assistant
SELECT Date FROM performance ORDER BY Attendance DESC LIMIT 1;
human
of the highest number of attendees | Did you mean to ask for the performance id of the performance with the highest number of attendees? | yes
assistant
SELECT Performance_ID FROM performance ORDER BY Attendance DESC LIMIT 1 ;