Regional Analytics

 

36. Revenue by Region

SELECT Region,
SUM(Amount)
FROM Sales
GROUP BY Region;

---

37. Highest Revenue Region

SELECT TOP 1
Region,
SUM(Amount)
FROM Sales
GROUP BY Region
ORDER BY SUM(Amount) DESC;

---

38. Lowest Revenue Region

Reverse sort.

---

39. Region Growth Rate

Use:

LAG()

---

40. Region Contribution %

Use:

SUM() OVER()