Adventure Sales by Year

gistfile1.cs

var salesPeople = 
	Person
	.Select(x => new { Name = x.FirstName + " " + x.LastName, x.BusinessEntityID });

SalesOrderHeader
	.Where(x => x.OnlineOrderFlag == false)
	.GroupBy(x => new { x.OrderDate.Year, x.SalesPersonID })
	.Select(x => new {
		Key = x.Key,
		Sales = x.Sum(y => y.SubTotal)
	})
	.Select(x => new { Year = x.Key.Year, SalesPerson = salesPeople.FirstOrDefault(y => y.BusinessEntityID == x.Key.SalesPersonID).Name, Sales =  x.Sales })
	.OrderByDescending(x => x.Sales)
	.GroupBy(x => x.Year)
	.OrderBy(x => x.Key)
	.Dump();