What are the names of the regions?
select region_name from region;
Show all region code and region name sorted by the region name alphabetically.
select region_code, region_name from region order by region_name asc;
Order the result by the codes.
select region_code, region_name from region order by region_code;