Advertisement
Guest User

Untitled

a guest
Feb 25th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.40 KB | None | 0 0
  1. SELECT MOQ.MONTH, AVG(MOQ.SUM) "Average"
  2. FROM
  3.     (SELECT MONTH(S_SOH.OrderDate) "Month", SUM(S_SOD_OQ.OQ) "Sum"
  4.     FROM Sales.SalesOrderHeader S_SOH
  5.         JOIN (SELECT S_SOD.SalesOrderID, SUM(OrderQty) "OQ" FROM Sales.SalesOrderDetail S_SOD GROUP BY S_SOD.SalesOrderID) S_SOD_OQ
  6.             ON S_SOH.SalesOrderID = S_SOD_OQ.SalesOrderID
  7.     GROUP BY MONTH(S_SOH.OrderDate), YEAR(S_SOH.OrderDate)) "MOQ"
  8. GROUP BY MOQ.MONTH;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement