1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
SELECT
count(distinct(`presence`.`Date`)) AS 'NB SEANCE',
count(distinct(SUBSTRING_INDEX(`presence`.`EnfantID`,':',1))) AS 'NB FAMILLE',
SUM(
IF((@a:=left((SUBSTRING_INDEX(`presence`.`EnfantID`,':',-1)),4)) = 'ENF_ ',1,0)
) AS 'NB_ENFANT',
SUM(
IF((@a:=left((SUBSTRING_INDEX(`presence`.`EnfantID`,':',-1)),4)) = 'GRO_ ',1,0)
) AS 'NB_GROSSESSE',
year(`presence`.`Date`) AS ANNEE,
month(`presence`.`Date`) AS MOIS
FROM
`presence`
GROUP BY
year(`presence`.`Date`),
month(`presence`.`Date`)
ORDER BY
year(`presence`.`Date`),
month(`presence`.`Date`) |
Partager