Database: decoration_competition
Question: Show the names of members and the locations of colleges they go to in ascending alphabetical order of member names.
SQL:
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