can we achieve this query using criteria API ..

Select *
From
(Select
A.ID as ID, A.NAME as NAME, A.IS_ACTIVE as ACTIVE,
LISTAGG(S.STATE_CD, ', ') WITHIN GROUP (ORDER BY A.ID,A.NAME) as STATES,
row_number()
over (order by lower(A.NAME) ASC) RN
From
Account A,
employee_account EA,
employee E
Where A.ID = EA.ID
AND EA.STATE_ID = E.ID
AND lower(A.NAME) like '%east%'
Group by A.ID, A.NAME, A.IS_ACTIVE)
where RN between 0 and 25
order by RN;