如何在C#中使用lambda或LINQ执行子查询、分组和聚合

var highScoreStudents = students.Where(s => s.Score > students.Average(s => s.Score));

var employeesByDepartment = employees.GroupBy(e => e.Department);

var totalSales = sales.Sum(s => s.Amount);
var averageSales = sales.Average(s => s.Amount);
var maxSales = sales.Max(s => s.Amount);
var minSales = sales.Min(s => s.Amount);

var highScoreStudents = from student in students
                        where student.Score > students.Average(s => s.Score)
                        select student;

var employeesByDepartment = from employee in employees
                            group employee by employee.Department into departmentGroup
                            select departmentGroup;

var totalSales = (from sale in sales select sale.Amount).Sum();
var averageSales = (from sale in sales select sale.Amount).Average();
var maxSales = (from sale in sales select sale.Amount).Max();
var minSales = (from sale in sales select sale.Amount).Min();