CREATE TABLE member (Name VARCHAR(255), College_ID VARCHAR(255)); CREATE TABLE college (College_Location VARCHAR(255), College_ID VARCHAR(255))
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