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