Page 1 of 1
✓a list of the store names (from the DimStore table) and the total sales (the sum of the column SalesAmount of the FactS
Posted: Tue Jul 12, 2022 8:17 am
by answerhappygod
- A List Of The Store Names From The Dimstore Table And The Total Sales The Sum Of The Column Salesamount Of The Facts 1 (28.99 KiB) Viewed 24 times
✓a list of the store names (from the DimStore table) and the total sales (the sum of the column SalesAmount of the FactSales table) of each store with the alias name TotalSales for the column in the result (think about INNER JOIN and GROUP BY). Order the result by TotalSales in the descending order (DESC)