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 different locations and the number of performances at each location.
assistant
SELECT LOCATION , COUNT( * ) FROM performance GROUP BY LOCATION;
human
Which is the least common location?
assistant
SELECT LOCATION FROM performance GROUP BY LOCATION ORDER BY COUNT( * ) ASC LIMIT 1 ;