✓a list of the store names (from the DimStore table) and the total sales (the sum of the column SalesAmount of the FactS

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

✓a list of the store names (from the DimStore table) and the total sales (the sum of the column SalesAmount of the FactS

Post 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
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 23 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)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”