Advertisement
Guest User

Untitled

a guest
Mar 24th, 2019
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. --Zadanie 2.2 NEW
  2. SELECT id.CustomerID, YEAR(OrderDate), COUNT(*) FROM(
  3. SELECT DISTINCT CustomerID FROM Sales.SalesOrderHeader WHERE YEAR(OrderDate) = 2011
  4. INTERSECT
  5. SELECT DISTINCT CustomerID FROM Sales.SalesOrderHeader WHERE YEAR(OrderDate) = 2014
  6. EXCEPT
  7. SELECT DISTINCT CustomerID FROM Sales.SalesOrderHeader WHERE YEAR(OrderDate) = 2012 OR YEAR(OrderDate) = 2013) as id
  8. JOIN Sales.SalesOrderHeader as sh ON (id.CustomerID = sh.CustomerID)
  9. GROUP BY id.CustomerID, YEAR(OrderDate)
  10. ORDER BY id.CustomerID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement