Error: Could not execute query
select
(SELECT p.NOMBRE_PROV FROM PROVINCIA p WHERE p.id_prov=i.prov_ing) AS PROVINCIA,
count(*) INVESTIGADOS
from INFORME_APT i
where TO_CHAR(i.fecha_ing, 'mm')=11 and TO_CHAR(i.fecha_ing, 'yyyy')=2024
group by i.prov_ing
in db_query()
