select d.*,me.nombre,
(select count(1) from esq_inscripciones.inscripcion i
join esq_mallas.malla_escuela me on me.idmalla = i.idmalla
where i.idpersonal = d.idpersonal
and i.idescuela <> -1
and i.idperiodo = ANY (
    select num
    FROM generate_series(190,191) AS num
    where d.fecha_inicio_periodo = '2024-04-01'
)
and me.codigo_caces  = d.codigo_carrera) as carrera1,
(select count(1) from esq_inscripciones.inscripcion i
join esq_mallas.malla_escuela me on me.idmalla = i.idmalla
where i.idpersonal = d.idpersonal
and i.idescuela <> -1
and i.idperiodo = ANY (
    select num
    FROM generate_series(202,203) AS num
    where d.fecha_inicio_periodo = '2024-10-01'
)
and me.codigo_caces  = d.codigo_carrera) as carrera2
from esq_evaluacion.estudiantes d
left join esq_mallas.malla_escuela me on me.codigo_caces = d.codigo_carrera
where me.estado = 'S'