Mid LINQ

How to calculate average salary per department?

How to calculate average salary per department?

var avgSalaryByDept = employees

.GroupBy(e => e.Department)

Follow :

.Select(g => new { Department = g.Key, AverageSalary =

g.Average(e => e.Salary) });

foreach (var dept in avgSalaryByDept)

Console.WriteLine($"{dept.Department}: {dept.AverageSalary}");

More from LINQ Tutorial

All questions for this course