CREATE TABLE performance (Location VARCHAR2, Performance_ID VARCHAR2)
CREATE TABLE member (Name VARCHAR2, Member_ID VARCHAR2)
CREATE TABLE member_attendance (Member_ID VARCHAR2, Performance_ID VARCHAR2)

Show the names of members and the location of performances they attended in ascending alphabetical order of their names.
SELECT T2.Name, T3.Location FROM member_attendance AS T1 JOIN member AS T2 ON T1.Member_ID = T2.Member_ID JOIN performance AS T3 ON T1.Performance_ID = T3.Performance_ID ORDER BY T2.Name
SELECT "T2"."Name", "T3"."Location" FROM "member_attendance" "T1" JOIN "member" "T2" ON "T1"."Member_ID" = "T2"."Member_ID" JOIN "performance" "T3" ON "T1"."Performance_ID" = "T3"."Performance_ID" ORDER BY "T2"."Name"