CREATE TABLE Ref_locations (location_code VARCHAR, location_name VARCHAR)

What is the location code for the country 'Canada'?
SELECT location_code FROM Ref_locations WHERE location_name = "Canada"
SELECT "location_code" FROM "Ref_locations" WHERE "Canada" = "location_name"