SELECT DISTINCT A1.serreg AS DRSE, A1.zonaescola AS ZONA, A2.CCT AS CLAVE_CT, A2.AUX10, COUNT( A3.OP1 ) AS ASPIRANTES
FROM cambios_centro_trabajo A1, escueladetalle A2, aspirante A3
WHERE A1.serreg = '11'
AND A2.AUX10 = 'CN'
AND A1.ct_id = A2.CCT
AND A1.ct_id = A3.OP1
GROUP BY A3.OP1