SELECT T2.Name ,  T1.College_Location FROM college AS T1 JOIN member AS T2 ON T1.College_ID  =  T2.College_ID ORDER BY T2.Name ASC
Show the names of members and the locations of colleges they go to in ascending alphabetical order of member names.
SELECT T2.Name , T1.College_Location FROM college AS T1 JOIN member AS T2 ON T1.College_ID = T2.College_ID ORDER BY T2.Name ASC
select t2 . name , t1 . college_location from college as t1 join member as t2 on t1 . college_id = t2 . college_id order by t2 . name asc
Show the names of members and the locations of colleges they go to in ascending alphabetical order of member names .