Advertisement
Guest User

Untitled

a guest
Dec 6th, 2019
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. Select A.CompanyName, Year(D.OrderDate), MONTH(D.OrderDate),Sum(C.UnitPrice * C.Quantity * (1-C.Discount)) as 'Przychod'
  2. From Suppliers as A
  3. INNER JOIN Products as B
  4. ON A.SupplierID = B.SupplierID
  5. INNER JOIN [Order Details] as C
  6. ON B.ProductID = C.ProductID
  7. INNER JOIN ORDERS as D
  8. ON D.OrderID = C.OrderID
  9. GROUP BY A.CompanyName, Year(D.OrderDate) ,MONTH(D.OrderDate)
  10. HAVING Sum(C.UnitPrice * C.Quantity * (1-C.Discount)) > (
  11. SELECT SUM(E.UnitPrice * E.Quantity * (1-E.Discount)) / (Select Count(A1.CompanyName)
  12. From Suppliers as A1
  13. INNER JOIN Products as B1
  14. ON A1.SupplierID = B1.SupplierID
  15. INNER JOIN [Order Details] as C1
  16. ON B1.ProductID = C1.ProductID
  17. INNER JOIN ORDERS as D1
  18. ON D1.OrderID = C1.OrderID
  19. WHERE
  20. Year(D.OrderDate) = YEAR(D1.OrderDate)
  21. AND MONTH(D.OrderDate) = MONTH(D1.OrderDate)
  22. )
  23. FROM [Order Details] as E
  24. INNER JOIN Orders as F
  25. ON F.OrderID = E.OrderID
  26. WHERE
  27. MONTH(F.OrderDate) = MONTH(D.OrderDate)
  28. AND YEAR(F.OrderDate) = YEAR(D.OrderDate)
  29. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement