Window Functions

SELECT region, sales_rep, amount,
       SUM(amount) OVER (PARTITION BY region) AS region_total,
       ROUND(amount * 100.0 / SUM(amount) OVER (PARTITION BY region), 1) AS pct_of_region
FROM sales
ORDER BY region, amount DESC;

SQL editor. Press Command or Control plus Enter to execute. Suggestions appear as you type; use the arrow keys to choose one and Enter or Tab to insert it, or Escape to dismiss.