Please show the names of all members who go to Saskatchewan School
select t2.name from college as t1 join member as t2 on t1.college_id = t2.college_id where t1.name = 'Saskatchewan School'
Now please show the names of all members, and the locations of the colleges they go to
select t2.name, t1.college_location from college as t1 join member as t2 on t1.college_id = t2.college_id
now can you show the those same results, but ordered in ascending order of member names
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