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

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" AS "T1" JOIN "member" AS "T2" ON "Canada" = "T2"."Country" AND "T1"."College_ID" = "T2"."College_ID"