human
Schema:
college (College_ID, Name, Leader_Name, College_Location)
member (Member_ID, Name, Country, College_ID)
round (Round_ID, Member_ID, Decoration_Theme, Rank_in_Round)
Please answer with SQL.
assistant
Sure, I understand.
human
show the total distinct leader names of the college associated with the members of all country
assistant
SELECT DISTINCT T1.Leader_Name FROM college AS T1 JOIN member AS T2 ON T1.College_ID = T2.College_ID;
human
find the college id for the college location Ottawa
assistant
SELECT college_id FROM college WHERE college_location = "Ottawa" ;