hi i am trying to solve the following problem

i have a list of messages and a message has a sender

for each sender i would like to list the amount of messages this person has posted in total

ideally i would have this be a single query. and in sql this would be possible with something like the following code

select m1.*, m2.total
from message m1
join (select sender_id, count(0) as total from messages group by sender_id) m2 on m1.sender_id = m2.sender_id

is it possible to accomplish this in jpa / hibernate ? i was looking for a way to join on a subselect but so far i havent found anything

User has a collection of products:



Results in:


Hope that helps