show the total distinct leader names of the college associated with the members of all country
select distinct t1.leader_name from college as t1 join member as t2 on t1.college_id = t2.college_id
find the college id for the college location Ottawa
select college_id from college where college_location = 'Ottawa'
find the member name and college location for the member id 1
select t2.name, t1.college_location from college as t1 join member as t2 on t2.college_id = t1.college_id where member_id = 1