What is the role of each member?
select role from member
How about their names?
select name from member
Show me in addition 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