CREATE TABLE region (region_code VARCHAR, region_name VARCHAR)

Show all region code and region name sorted by the codes.
SELECT region_code, region_name FROM region ORDER BY region_code
SELECT "region_code", "region_name" FROM "region" ORDER BY "region_code" NULLS FIRST