org.hibernate.query.SemanticException: Select item at position 1 in select list has no alias (aliases are required in CTEs and in subqueries occurring in from clause)
String hql1 = """
SELECT COUNT(d.id) FROM (SELECT
rule
FROM
UserGroupDynamicRuleEntity rule
INNER JOIN UserGroupEntity group ON rule.userGroupId = group.id
WHERE
group.type=:type) d
""";
TypedQuery<Integer> query1 = entityManager.createQuery(hql1,
Integer.class);