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
Show me the dates of the performances.
assistant
SELECT Date FROM performance;
human
How about the attendances?
assistant
SELECT Attendance FROM performance;
human
Among the results, which are performed at 'TD Garden' or 'Bell Centre'?
assistant
SELECT Attendance FROM performance WHERE LOCATION = "TD Garden" OR LOCATION = "Bell Centre" ;