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.
PRAGMA foreign_keys = ON;

CREATE TABLE "college" (
"College_ID" int,
"Name" text,
"Leader_Name" text,
"College_Location" text,
PRIMARY KEY ("College_ID")
);



INSERT INTO  "college" VALUES ("1","Saskatchewan School","Ousame Tounkara","Ottawa");
INSERT INTO  "college" VALUES ("2","B.C. School","Ryan Thelwell","Minnesota");
INSERT INTO  "college" VALUES ("3","Calgary School","Andre Arlain","St. Francis Xavier");
INSERT INTO  "college" VALUES ("4","Edmonton School","Samir Chahine","McGill");
INSERT INTO  "college" VALUES ("5","Toronto School","Roger Dunbrack","Western Ontario");


CREATE TABLE "member" (
"Member_ID" int,
"Name" text,
"Country" text,
"College_ID" int,
PRIMARY KEY ("Member_ID"),
FOREIGN KEY ("College_ID") REFERENCES `college`("College_ID")
);


INSERT INTO  "member" VALUES ("1","Jack Nicklaus","United States",1);
INSERT INTO  "member" VALUES ("2","Billy Casper","United States",1);
INSERT INTO  "member" VALUES ("3","Arnold Palmer","Canada",4);
INSERT INTO  "member" VALUES ("4","Tom Watson","United States",4);
INSERT INTO  "member" VALUES ("5","Homero Blancas","United States",2);
INSERT INTO  "member" VALUES ("6","Pat Fitzsimons","Canada",5);
INSERT INTO  "member" VALUES ("7","Bobby Nichols","Canada",5);
INSERT INTO  "member" VALUES ("8","J. C. Snead","Canada",4);
INSERT INTO  "member" VALUES ("9","Lee Trevino","United States",3);
INSERT INTO  "member" VALUES ("10","Tom Weiskopf","United States",3);


CREATE TABLE "round" (
"Round_ID" int,
"Member_ID" int,
"Decoration_Theme" text,
"Rank_in_Round" int,
PRIMARY KEY ("Member_ID","Round_ID"),
FOREIGN KEY ("Member_ID") REFERENCES "member"("Member_ID")
);


INSERT INTO  "round" VALUES (1,1,"Walk on the Moon",1);
INSERT INTO  "round" VALUES (1,2,"Soft Dream",2);
INSERT INTO  "round" VALUES (1,10,"Dark Nights",4);
INSERT INTO  "round" VALUES (2,4,"Sweetie",3);
INSERT INTO  "round" VALUES (2,6,"Summer",2);
INSERT INTO  "round" VALUES (2,9,"Happiness",1);


('Arnold Palmer', 'McGill')
('Billy Casper', 'Ottawa')
('Bobby Nichols', 'Western Ontario')
('Homero Blancas', 'Minnesota')
('J. C. Snead', 'McGill')
('Jack Nicklaus', 'Ottawa')
('Lee Trevino', 'St. Francis Xavier')
('Pat Fitzsimons', 'Western Ontario')
('Tom Watson', 'McGill')
('Tom Weiskopf', 'St. Francis Xavier')
