.OrderBy(s => s.City) .ThenBy(s => s.Location) .Select(s => new { City = s.City, Location = s.Location, Sales = Orders .Where(dateGroup => s.StoreID == dateGroup.StoreID && dateGroup.OrderDate.Month == 12) .GroupBy(o => new {o.OrderDate}) .Select(s => new { Sales = s.Key.OrderDate, NumberOfOrders = s.Count(), }) }) .Dump();