Question
How can analytic SQL calculate each region’s percentage of total sales without a self-join?
Select an option. Your answer will be checked instantly.
Correct Answer: C. Divide regional sales by SUM(regional sales) OVER ()
Explanation:
A window SUM over all result rows supplies the denominator while retaining each region.
The regional amount divided by that total yields its share.
Leave a Reply