SELECT location_code FROM Ref_locations WHERE location_name  =  "Canada"
Show the location code of the country "Canada".
SELECT location_code FROM Ref_locations WHERE location_name = `` Canada ''
select location_code from ref_locations where location_name = value
Show the location code of the country `` Canada '' .