Error: Could not execute query select
(SELECT p.NOMBRE_PROV FROM PROVINCIA p WHERE p.id_prov=x.prov_ing) AS PROVINCIA,
prov_ing, sum(num_part) as PARTICIPANTE, count(*) TOTAL,
round((sum(cal_estudiante)/count(*)),2) as TOTAL_EST,
round((sum(cal_capacitador)/count(*)),2) as TOTAL_CAP
from capacitacion x
where TO_CHAR(x.fecha_ing, 'mm')=12 and TO_CHAR(x.fecha_ing, 'yyyy')=2024
group by x.prov_ing
in db_query()