Jagadish Rapuru

// LINQ Query - Filter, Group & Transform Data
var employees = new List<Employee>
{
    new("Jagadish", "Engineering", 95000, 5),
    new("John", "Engineering", 85000, 3),
    new("Sarah", "Marketing", 75000, 4),
    new("Mike", "Engineering", 90000, 4),
    new("Lisa", "Marketing", 80000, 2)
};

// Complex LINQ: Group by department, filter, and project
var departmentStats = employees
    .Where(e => e.YearsOfExp >= 3)
    .GroupBy(e => e.Department)
    .Select(g => new
    {
        Department = g.Key,
        AvgSalary = g.Average(e => e.Salary),
        TopPerformer = g.OrderByDescending(e => e.Salary).First().Name,
        Count = g.Count()
    })
    .OrderByDescending(d => d.AvgSalary);

foreach (var dept in departmentStats)
{
    Console.WriteLine(dept.Department + ": Avg " + dept.AvgSalary);
}

record Employee(string Name, string Department, decimal Salary, int YearsOfExp);