CREATE TABLE Ref_locations (location_code VARCHAR, location_name VARCHAR)

List all location codes and location names.
SELECT location_code, location_name FROM Ref_locations
SELECT "location_code", "location_name" FROM "Ref_locations"