https://micxep.blogspot.com/2023/05/cannot-mix-aggregate-and-non-aggregate.html