Product Analytics

31. Best Selling Product

SELECT ProductID,
SUM(Quantity)
FROM Sales
GROUP BY ProductID;

Order descending.

---

32. Worst Selling Product

Order ascending.

---

33. Products Never Sold

SELECT p.*
FROM Products p
LEFT JOIN Sales s
ON p.ProductID=s.ProductID
WHERE s.ProductID IS NULL;

---

34. Average Product Revenue

SELECT AVG(ProductRevenue)
FROM
(
SELECT ProductID,
SUM(Amount) ProductRevenue
FROM Sales
GROUP BY ProductID
)x;

---

35. Product Revenue Contribution

Same pattern as Pareto.

---

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()