Junior — Middle

How can you select employees with an average salary above 50,000 conditional units in a table?

sobes.tech AI

Answer from AI

To select employees with an average salary above 50,000 conditional units, you can use LINQ in C# for grouping and filtering data. Suppose you have a collection of employees with fields EmployeeId and Salary.

Example:

var result = employees
    .GroupBy(e => e.EmployeeId)
    .Where(g => g.Average(e => e.Salary) > 50000)
    .Select(g => new {
        EmployeeId = g.Key,
        AverageSalary = g.Average(e => e.Salary)
    });

foreach (var employee in result)
{
    Console.WriteLine($"Employee {employee.EmployeeId} has an average salary of {employee.AverageSalary}");
}

If working with a database and SQL, the query would look like:

SELECT EmployeeId, AVG(Salary) as AverageSalary
FROM Employees
GROUP BY EmployeeId
HAVING AVG(Salary) > 50000;

This query groups records by employees, calculates the average salary, and selects only those with an average above 50,000.

Previous Next