Using GROUP BY in JPA

Question

I am having a @ManyToMany relationship between a Question entity and a Category entity. I want to count the number of questions in each category. How would I do that?

Answer 1

select count(question.id), category.description 
from Category category
left join category.questions question
group by category.description