What are the name and description for location code x?
CREATE TABLE Ref_locations (location_name VARCHAR, location_description VARCHAR, location_code VARCHAR)
[SQL] SELECT location_name, location_description FROM Ref_locations WHERE location_code = "x" [/SQL]