SELECT TOTAL_ALUMNOS_FS = (select count(*) from Listas L JOIN Alumnos A ON L.RFC_Alumno = A.RFC_Alumno JOIN Grupos G ON L.Clv_cva_grp = G.Clv_cva_Grp Where (G.Bimestre = '1118' OR G.Bimestre = '2118' OR G.Bimestre = '3118' OR G.Bimestre = '4118' OR G.Bimestre = '5118') AND G.CANCELADO = 0 AND G.Grado NOT LIKE '%Z%' AND G.Nivel NOT LIKE 'EU' ) , TOTAL_ALUMNOS_S = (select count(*) from Listas L JOIN Alumnos A ON L.RFC_Alumno = A.RFC_Alumno JOIN Grupos G ON L.Clv_cva_grp = G.Clv_cva_Grp Where (G.Bimestre = '1118' OR G.Bimestre = '2118' OR G.Bimestre = '3118' OR G.Bimestre = '4118' OR G.Bimestre = '5118' OR G.Bimestre = '0118') AND G.CANCELADO = 0 AND G.Grado NOT LIKE '%Z%' AND G.Nivel NOT LIKE 'EU' ), TOTALBECADOS = (select count(*) from Listas L JOIN Alumnos A ON L.RFC_Alumno = A.RFC_Alumno JOIN Grupos G ON L.Clv_cva_grp = G.Clv_cva_Grp Where (G.Bimestre = '1118' OR G.Bimestre = '2118' OR G.Bimestre = '3118' OR G.Bimestre = '4118' OR G.Bimestre = '5118' OR G.Bimestre = '0118') AND (G.CANCELADO = 0 AND G.Grado NOT LIKE '%Z%' AND G.Nivel NOT LIKE 'EU' ) AND A.ClvTipo = 'B'), TOTALEMPLEADOS = (select count(*) from Listas L JOIN Alumnos A ON L.RFC_Alumno = A.RFC_Alumno JOIN Grupos G ON L.Clv_cva_grp = G.Clv_cva_Grp Where (G.Bimestre = '1118' OR G.Bimestre = '2118' OR G.Bimestre = '3118' OR G.Bimestre = '4118' OR G.Bimestre = '5118' OR G.Bimestre = '0118') AND (G.CANCELADO = 0 AND G.Grado NOT LIKE '%Z%' AND G.Nivel NOT LIKE 'EU' ) AND A.ClvTipo = 'E'), TOTALEGRESADOS = (select count(*) from Listas L JOIN Alumnos A ON L.RFC_Alumno = A.RFC_Alumno JOIN Grupos G ON L.Clv_cva_grp = G.Clv_cva_Grp Where (G.Bimestre = '1118' OR G.Bimestre = '2118' OR G.Bimestre = '3118' OR G.Bimestre = '4118' OR G.Bimestre = '5118' OR G.Bimestre = '0118') AND (G.CANCELADO = 0 AND G.Grado NOT LIKE '%Z%' AND G.Nivel NOT LIKE 'EU' ) AND A.ClvTipo = 'G'), TOTALINCORPALUM = (select count(*) from Listas L JOIN Alumnos A ON L.RFC_Alumno = A.RFC_Alumno JOIN Grupos G ON L.Clv_cva_grp = G.Clv_cva_Grp Where (G.Bimestre = '1118' OR G.Bimestre = '2118' OR G.Bimestre = '3118' OR G.Bimestre = '4118' OR G.Bimestre = '5118' OR G.Bimestre = '0118') AND (G.CANCELADO = 0 AND G.Grado NOT LIKE '%Z%' AND G.Nivel NOT LIKE 'EU' ) AND A.ClvTipo = 'I'), TOTALEGRESINCORP = (select count(*) from Listas L JOIN Alumnos A ON L.RFC_Alumno = A.RFC_Alumno JOIN Grupos G ON L.Clv_cva_grp = G.Clv_cva_Grp Where (G.Bimestre = '1118' OR G.Bimestre = '2118' OR G.Bimestre = '3118' OR G.Bimestre = '4118' OR G.Bimestre = '5118' OR G.Bimestre = '0118') AND (G.CANCELADO = 0 AND G.Grado NOT LIKE '%Z%' AND G.Nivel NOT LIKE 'EU' ) AND A.ClvTipo = 'N'), TOTALPOLITECNICO = (select count(*) from Listas L JOIN Alumnos A ON L.RFC_Alumno = A.RFC_Alumno JOIN Grupos G ON L.Clv_cva_grp = G.Clv_cva_Grp Where ( G.Bimestre = '1118' OR G.Bimestre = '2118' OR G.Bimestre = '3118' OR G.Bimestre = '4118' OR G.Bimestre = '5118' OR G.Bimestre = '0118') AND (G.CANCELADO = 0 AND G.Grado NOT LIKE '%Z%' AND G.Nivel NOT LIKE 'EU' ) AND A.ClvTipo = 'P'), TOTALEXTERNO = (select count(*) from Listas L JOIN Alumnos A ON L.RFC_Alumno = A.RFC_Alumno JOIN Grupos G ON L.Clv_cva_grp = G.Clv_cva_Grp Where (G.Bimestre = '1118' OR G.Bimestre = '2118' OR G.Bimestre = '3118' OR G.Bimestre = '4118' OR G.Bimestre = '5118' OR G.Bimestre = '0118') AND (G.CANCELADO = 0 AND G.Grado NOT LIKE '%Z%' AND G.Nivel NOT LIKE 'EU' ) AND A.ClvTipo = 'X')