I have this query
select distinct p.nombre,
p.total,
p.clie_id
from(select cli.nombre as nombre,
cli.clie_id,
cue.cuen_id as cuenta,
count(cue.clie_id) over(partition by cli.clie_id) as total
from Cuenta cue,
Cliente cli
where cue.clie_id = cli.clie_id) as p
where total > 1 order by p.clie_id asc;
But I need to pass it to JPQL
.