Skip to content
RED SAGSkills
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;
Choose one answer

Discussion 0

Join free to post in the discussion.

Related questions