Show the code for all locations.
select location_code from ref_locations
How about the one named "Canada"?
select location_code from ref_locations