Show me all about the members.
select * from member
What are the dates of performances that each of them attended? Show name and date.
select t2.name, t3.date 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
Sort the result in descending order of attendance of the performances.
select t2.name, t3.date 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 t3.attendance desc