Yes
select count ( distinct performance_id ) from member_attendance
What are the roles for each performance?
select t2.performance_id,t1.role from member as t1 join member_attendance as t2 on t1.member_id = t2.member_id group by t2.performance_id
yes
select name ,nationality from member