Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT oh.SalesPersonID AS perID,
- YEAR(oh.OrderDate) AS [Year], COUNT(*)
- FROM Sales.SalesOrderHeader oh
- JOIN Person.Person per ON oh.SalesPersonID = per.BusinessEntityID
- GROUP BY SalesPersonID, YEAR(OrderDate)
- ORDER BY perID, [Year];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement