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')