CREATE TABLE college (Leader_Name VARCHAR2, College_ID VARCHAR2)
CREATE TABLE member (College_ID VARCHAR2, Country VARCHAR2)

Show the distinct leader names of colleges associated with members from country 'Canada'.
SELECT DISTINCT T1.Leader_Name FROM college AS T1 JOIN member AS T2 ON T1.College_ID = T2.College_ID WHERE T2.Country = "Canada"
SELECT DISTINCT "T1"."Leader_Name" FROM "college" "T1" JOIN "member" "T2" ON "Canada" = "T2"."Country" AND "T1"."College_ID" = "T2"."College_ID"