Code below works in EF Core 6.0. But failed on EF Core 8.0. I found the same issue #29201, but it was closed. The solution that was proposed only works with the Sum method.