Hibernate criteria query predicate avg value of children one to many collection

Hibernate predicate

 @Override
        public Predicate toPredicate(Root<ParentEntity> root, CriteriaQuery<?> query, CriteriaBuilder cb) {
            List<Predicate> predicates = new ArrayList<>();

            if (filters.isEmpty()) {
                return cb.conjunction();
            }

            Subquery<Long> countChildren = query.subquery(Long.class);
            Root<ChildEntity> countChildrenRoot = countVotes.from(ChildEntity.class);
            Join countChildrenJoin = countChildrenRoot.join("parentField");
            countChildren.select(cb.count(countChildrenRoot.get(ID)));
            countChildren.where(cb.equal(root.get(ID), countChildrenJoin.get(ID)));

            Subquery<Long> sumChildren = query.subquery(Long.class);
            Root<ChildEntity> sumChildrenRoot = sumChildren.from(ChildEntity.class);
            Join sumChildrenJoin = sumChildrenRoot.join("parentField");
            sumChildren.select(cb.sum(sumChildrenRoot.get("intField")));
            sumChildren.where(cb.equal(root.get(ID), sumChildrenJoin.get(ID)));

            Map<String, Expression> col = ImmutableMap.<String, Expression>builder()
                    .put("avgChildren", cb.quot(sumChildren, countChildren))
                    .build();

          
            if (filters.get("avgChildren") != null) {
                List<Double> range = (List<Double>) filters.remove("avgChildren");
                Assert.isTrue(range.size() == 2, "Range " + range + " should have 2 elements");
                predicates.add(cb.and(cb.between(col.get("avgChildren"), range.get(0), range.get(1))));
            }

Using formula

 @Formula("(select sum(v1.int_field) from child_entity_table v1 where v1.parent_id = id)" +
            "/" +
            "(select count(v2.id) from child_entity_table v2 where v2.parent_id = id)")
private Float calculatedField;

@Formula("(select avg(c1.int_field * 1.0) from child_entity_table c1 where c1.parent_id = id)")
private Double calculatedField;