Error: Could not execute query
select
(SELECT p.NOMBRE_PROV FROM PROVINCIA p WHERE p.id_prov=e.id_prov) AS PROVINCIA,
count(*) TOTAL
from expediente e
inner join CALIFICACION_AT c on c.id_exp=e.id_exp
where e.fallecido like 'SI' and c.califica_at like 'SI'
and TO_CHAR(c.fecha_cal, 'mm')=12 and TO_CHAR(c.fecha_cal, 'yyyy')=2024
GROUP BY e.id_prov
in db_query()