Show all region code and region name sorted by the codes.
SELECT region_code ,  region_name FROM region ORDER BY region_code
show all region code and region name refers to SELECT region_code, region_name; sorted by the codes refers to ORDER BY region_code;