08 Aug Analytical Query is aggregation query with a few dimensions and facts.
Sales Order Analytical Reports. …….PATH A
Aggregation:
In Week 6 sales order view Week6_sales_vi was created joining all sales order tables in your database.
HINT: Analytical Query is aggregation query with a few dimensions and facts.
by Year means year(SalesOrderDate)
1. Summarized TotalAmount ( SUM(OrderAmount) by Year, Region, Customer, ProductFamily
2. Summarized TotalAmount and TotalAmountCommision by Year, Manager, Agent
upload SQL and Result
