This query returns pure Canadian companies by searching for companies with IID ending with C and Stock Exchange Code (EXCHG) = 7-10 to represent the Canadian exchanges, which are both from the Security table, and Country of Incorporation (FIC) = CAN (Canada) from the Company table