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

Show different locations and the number of performances at each location.
SELECT location, COUNT(*) FROM performance GROUP BY location
SELECT "location", COUNT(*) FROM "performance" GROUP BY "location"