Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. SELECT oh.SalesPersonID AS perID,
  2. YEAR(oh.OrderDate) AS [Year], COUNT(*)
  3. FROM Sales.SalesOrderHeader oh
  4. JOIN Person.Person per ON oh.SalesPersonID = per.BusinessEntityID
  5. GROUP BY SalesPersonID, YEAR(OrderDate)
  6. ORDER BY perID, [Year];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement