-- Database schema
| college : College_ID [ INT ] primary_key , Name [ TEXT ] , Leader_Name [ TEXT ] , College_Location [ TEXT ] | member : Member_ID [ INT ] primary_key , Name [ TEXT ] , Country [ TEXT ] , College_ID [ INT ] member.College_ID = college.College_ID | round : Round_ID [ INT ] , Member_ID [ INT ] primary_key round.Member_ID = member.Member_ID , Decoration_Theme [ TEXT ] , Rank_in_Round [ INT ] |
-- -- 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;