SELECT location_code FROM Ref_locations WHERE location_name  =  "Canada"
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 location_name = value
What is the location code for the country `` Canada '' ?