Nested .GroupBy Query - StackOverflowException

[alienwareone]

using EfCore 6.0.1

The following Linq query throws a StackOverflowException.

var result = applicationDbContext.PageImpressions
    .GroupBy(x => x.CreationDateTime.Date)
    .Select(x => new
    {
        TotalCount = x.Count(),
        UniqueIpAddressCount = x.GroupBy(x => x.IpAddress).Count(),
        UniqueUserAgentCount = x.GroupBy(x => x.UserAgent).Count()
    })
    .ToList();

Minimal Repo:
https://github.com/alienwareone/EfCoreNestedGroupByError

[smitpatel]

Duplicate of #27094