

select country, area, region
from country_dimension
join regions              on country_dimension.region_id = regions.region_id
join area_contains_region on country_dimension.region_id = area_contains_region.region_id
join areas                on               areas.area_id = area_contains_region.area_id
order by country ;

