Show the names of members and the locations of colleges they go to in ascending alphabetical order of member names.
CREATE TABLE college (
    College_Location VARCHAR,
    College_ID VARCHAR
)

CREATE TABLE member (
    Name VARCHAR,
    College_ID VARCHAR
)
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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show the names of members and the locations of colleges they go to in ascending alphabetical order of member names. ### Input: CREATE TABLE college (
    College_Location VARCHAR,
    College_ID VARCHAR
)

CREATE TABLE member (
    Name VARCHAR,
    College_ID VARCHAR
) ### Response: 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