

-- REGION                           TOTAL
-- -------------------------------  -----

select region, sum(total) as total 
from release_dates_fact_table
join date_dimension       on    date_dimension.release_date = release_dates_fact_table.release_date
join country_dimension    on      country_dimension.country = release_dates_fact_table.country 
join regions              on              regions.region_id = country_dimension.region_id 
join area_contains_region on area_contains_region.region_id = country_dimension.region_id 
join areas                on                  areas.area_id = area_contains_region.area_id
group by region
order by total desc, region
; 
