SELECT r.region_name, sum(f.amount)
FROM fact_sales f
JOIN dim_store d ON f.store_sk = d.store_sk
JOIN dim_region r ON d.region_sk = r.region_sk
GROUP BY 1;