Transforming Native SQL to JPQL: Leveraging CTEs and `@SqlResultSetMapping`

How to Use Subselect, Group by, and Having Count with Criteria in Hibernate