Try AskLytix Live

SELECT 
  st.Region,
  st.State,
  COUNT(DISTINCT s.OrderID) as TotalOrders,
  SUM(s.TotalAmount) as TotalSales,
  AVG(s.TotalAmount) as AvgOrderValue,
  COUNT(DISTINCT s.CustomerKey) as UniqueCustomers
FROM FactSales s
JOIN DimStore st ON s.StoreKey = st.StoreKey
WHERE s.OrderDate >= DATEADD(YEAR, -1, GETDATE())
GROUP BY st.Region, st.State
ORDER BY TotalSales DESC;