medium10 pts · first answer countswindow-functionssql
Share of total after GROUP BY
You group sales by region and also want each region's share of the grand total. Which SELECT expression is valid?
SELECT region, SUM(amount) AS total, ??? AS share FROM sales GROUP BY region;
Discussion 0
Join free to post in the discussion.