How to extract a list of departments and their average salaries from a table containing fields for name, department, and salary?

To extract a list of departments and their average salaries in C#, you can use LINQ if the data is represented as a collection of objects. For example:

var averageSalaries = employees
    .GroupBy(e => e.Department)
    .Select(g => new {
        Department = g.Key,
        AverageSalary = g.Average(e => e.Salary)
    });

foreach (var dept in averageSalaries)
{
    Console.WriteLine($"Department: {dept.Department}, Average Salary: {dept.AverageSalary}");
}

If the data is in a database, you can write an SQL query:

SELECT Department, AVG(Salary) AS AverageSalary
FROM Employees
GROUP BY Department;