What is the location code for the country "Canada"?
CREATE TABLE Ref_locations (location_code VARCHAR, location_name VARCHAR)
SELECT location_code FROM Ref_locations WHERE location_name = "Canada"
### Context: CREATE TABLE Ref_locations (location_code VARCHAR, location_name VARCHAR) ### Question: What is the location code for the country "Canada"? ### Answer: SELECT location_code FROM Ref_locations WHERE location_name = "Canada"