Level 7 - ArchitectQuery-Based Questionsm4 dimensional performance models
Star Query: Monthly Revenue by Region
Return month_start, region_name, and total_revenue for paid orders in Jan-Mar 2025.
Schema Context
fact_sales(date_sk, region_sk, amount, order_status), dim_date(date_sk, month_start, full_date), dim_region(region_sk, region_name)