What are the name and description for location code x?
create table ref_locations (location_name varchar, location_description varchar, location_code varchar, PRIMARY KEY (location_name))
select location_name, location_description from ref_locations where location_code = "x"