Show me the names of the members.
select name from member
Sort the result in ascending alphabetical order.
select name from member order by name asc
Also provide the locations 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 order by t2.name asc