编写LINQ查询以透视结果

// 假设有一个包含学生信息的集合
List<Student> students = new List<Student>
{
    new Student { Name = "Alice", Age = 18, Grade = "A" },
    new Student { Name = "Bob", Age = 19, Grade = "B" },
    new Student { Name = "Charlie", Age = 18, Grade = "A" },
    new Student { Name = "David", Age = 20, Grade = "C" },
    new Student { Name = "Eve", Age = 19, Grade = "B" }
};

// 使用LINQ查询来透视结果，按年龄分组并计算每个年龄组的学生人数
var result = from student in students
             group student by student.Age into ageGroup
             select new
             {
                 Age = ageGroup.Key,
                 Count = ageGroup.Count()
             };

// 输出结果
foreach (var item in result)
{
    Console.WriteLine($"Age: {item.Age}, Count: {item.Count}");
}