Who are all the members from the country Canada?
select member_id from member where country = "Canada"
What are the names of the colleges they go to?
select t2.member_id, t1.name from college as t1 join member as t2 on t1.college_id = t2.college_id where t2.country = "Canada"
Who are the team leaders of these colleges?
select t2.member_id, t1.name, t1.leader_name from college as t1 join member as t2 on t1.college_id = t2.college_id where t2.country = "Canada"
Show me a list of all the different leaders!
select distinct t1.leader_name from college as t1 join member as t2 on t1.college_id = t2.college_id where t2.country = "Canada"