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 INFORME_CVI t
inner join calificacion_at c on c.id_exp=t.id_exp and c.califica_at='SI'
inner join expediente e on e.id_exp=c.id_exp
where t.tipo_incapacidad='PAR' and TO_CHAR(fecha_acuerdo, 'mm')=12 and TO_CHAR(fecha_acuerdo, 'yyyy')=2024
group by e.id_prov
in db_query()