What is the location code for the country "Canada"?
create table ref_locations (location_code varchar, location_name varchar, PRIMARY KEY (location_code))
select location_code from ref_locations where location_name = "canada"