c#使用linq按数据表中的多个列进行分组

var students = new[]
{
    new { Name = "Alice", Grade = "A", Score = 90 },
    new { Name = "Bob", Grade = "B", Score = 80 },
    new { Name = "Charlie", Grade = "A", Score = 85 },
    new { Name = "David", Grade = "C", Score = 70 },
    new { Name = "Eva", Grade = "B", Score = 95 },
};

var groupedStudents = students.GroupBy(student => new { student.Grade, student.Score })
                              .Select(group => new
                              {
                                  group.Key.Grade,
                                  group.Key.Score,
                                  Students = group.Select(student => student.Name).ToList()
                              })
                              .OrderByDescending(group => group.Score)
                              .ThenBy(group => group.Grade);

foreach (var group in groupedStudents)
{
    Console.WriteLine($"Grade: {group.Grade}, Score: {group.Score}");
    foreach (var student in group.Students)
    {
        Console.WriteLine($"  - {student}");
    }
}

Grade: A, Score: 90
  - Alice
Grade: A, Score: 85
  - Charlie
Grade: B, Score: 80
  - Bob
Grade: B, Score: 95
  - Eva
Grade: C, Score: 70
  - David