Adventure Sales by Year

gistfile1.sql

SELECT data.[Year], p.FirstName + ' ' + p.LastName, data.Amount FROM
(
	SELECT DATEPART(Year, OrderDate) as [Year], SalesPersonID, SUM(subtotal) as Amount  FROM 
	Sales.SalesOrderHeader
	WHERE OnlineOrderFlag = 0
	GROUP BY DATEPART(Year, OrderDate), SalesPersonID
) data
INNER JOIN Person.Person as [p] ON data.SalesPersonID = p.BusinessEntityID
ORDER BY [Year], Amount DESC