1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| SELECT
SUM(CASE WHEN ( eleves.situat= 6 ) THEN 1 ELSE 0 END ) AS Q,
SUM(CASE WHEN ( eleves.situat= 5 ) THEN 1 ELSE 0 END ) AS A,
SUM(CASE WHEN ( eleves.situat= 4 ) THEN 1 ELSE 0 END ) AS N,
SUM(CASE WHEN ( eleves.situat= 3 ) THEN 1 ELSE 0 END ) AS C,
SUM(CASE WHEN ( eleves.situat = 2 ) THEN 1 ELSE 0 END ) AS I,
SUM(CASE WHEN ( eleves.situat= 1 ) THEN 1 ELSE 0 END ) AS V,
SUM(CASE WHEN ( eleves.situat = 0 ) THEN 1 ELSE 0 END ) AS E,
eleves.genre AS genre,
eleves.clas AS clas,
eleves.genre AS genre_invisible,
eleves.clas AS clas_invisible
FROM
eleves
WHERE
eleves.cdecol like '%1'
GROUP BY
eleves.genre,
eleves.clas
union
select
SUM(CASE WHEN ( eleves.situat= 6 ) THEN 1 ELSE 0 END ) AS Q,
SUM(CASE WHEN ( eleves.situat= 5 ) THEN 1 ELSE 0 END ) AS A,
SUM(CASE WHEN ( eleves.situat= 4 ) THEN 1 ELSE 0 END ) AS N,
SUM(CASE WHEN ( eleves.situat= 3 ) THEN 1 ELSE 0 END ) AS C,
SUM(CASE WHEN ( eleves.situat = 2 ) THEN 1 ELSE 0 END ) AS I,
SUM(CASE WHEN ( eleves.situat= 1 ) THEN 1 ELSE 0 END ) AS V,
SUM(CASE WHEN ( eleves.situat = 0 ) THEN 1 ELSE 0 END ) AS E,
null as genre,
null as clas,
'zzzz' as genre_invisible,
'zzzz' as clas_invisible
FROM
eleves
WHERE
eleves.cdecol like '%1' |
Partager