Applications that use the Jakarta Persistence API shouldn’t embed too much raw SQL in their code. However, when you need an SQL query for performance reasons or to access the database in a way that ...

SQL doesn't like us when we use a GROUP BY clause with that sub-query, because the sub-query isn't included in an aggregate.