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
Tunjukkan nama -nama anggota dan lokasi perguruan tinggi yang mereka kunjungi dalam urutan abjad nama anggota.
CREATE TABLE member (Name VARCHAR, College_ID VARCHAR); CREATE TABLE college (College_Location VARCHAR, College_ID VARCHAR)