-- Database schema
| member : Member_ID [ TEXT ] primary_key , Name [ TEXT ] , Nationality [ TEXT ] , Role [ TEXT ] | performance : Performance_ID [ INT ] primary_key , Date [ TEXT ] , Host [ TEXT ] , Location [ TEXT ] , Attendance [ INT ] | member_attendance : Member_ID [ INT ] primary_key member_attendance.Member_ID = member.Member_ID , Performance_ID [ INT ] member_attendance.Performance_ID = performance.Performance_ID , Num_of_Pieces [ INT ] |
-- -- Show the names of members and the location of the performances they attended.

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;