CREATE TABLE "member" (
    "Member_ID" text,
    "Name" text,
    "Nationality" text,
    "Role" text,
    PRIMARY KEY ("Member_ID")
)

CREATE TABLE "performance" (
    "Performance_ID" real,
    "Date" text,
    "Host" text,
    "Location" text,
    "Attendance" int,
    PRIMARY KEY ("Performance_ID")
)

CREATE TABLE "member_attendance" (
    "Member_ID" int,
    "Performance_ID" int,
    "Num_of_Pieces" int,
    PRIMARY KEY ("Member_ID","Performance_ID"),
    FOREIGN KEY ("Member_ID") REFERENCES `member`("Member_ID"),
    FOREIGN KEY ("Performance_ID") REFERENCES `performance`("Performance_ID")
)
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
Show the names of members and the location of the performances they attended.