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

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"