What are the names of all the members in alphabetical order?
select name from member order by name asc
Also provide their college names.
select t2.name, t1.name from college as t1 join member as t2 on t1.college_id = t2.college_id order by t2.name asc
and their college locations!
select t2.name, t1.name, t1.college_location from college as t1 join member as t2 on t1.college_id = t2.college_id order by t2.name asc
actually, show just the names and locations.
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