I am wondering if Hibernate handle nested aggregate function.

I am trying to find sum of average rating of articles for each user. I would also like to do rounding of this sum of avg rating..

Any Idea how to do this? Pl. let me know if more information is required in understanding the problem.. I am using msql db and hibernate 3.0

select r.article.user.userId, sum(avg(r.rating)) as points from Rating r group by r.article

Below is mysql query for this issue...It works perfectly fine and gives desired results...I tried coverting it to HQL but no luck...any thought, how to convert it to hql??

Quote:

select userId, round(sum(avgrating)) as points from (select a.User_Id as userId , avg(r.rating) as avgrating from article a, rating r where a.article_id = r.article_id group by r.article_id) as ratingsum group by userId order by sum(avgrating) desc