CREATE TABLE member_attendance (Member_ID INT, Performance_ID INT, Num_of_Pieces INT)
CREATE TABLE member (Member_ID TEXT, Name TEXT, Nationality TEXT, Role TEXT)
CREATE TABLE performance (Performance_ID FLOAT, Date TEXT, Host TEXT, Location TEXT, Attendance INT)

Bar chart x axis location y axis how many location, and rank by the bars in asc.
SELECT Location, COUNT(Location) FROM performance GROUP BY Location ORDER BY Location
SELECT "Location", COUNT("Location") FROM "performance" GROUP BY "Location" ORDER BY "Location" NULLS FIRST