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
| SELECT
'ADMINISTRATIF',
COUNT(SUBSTR(Contact.AppellantID,0,4)) AS TOTAL,
SUM(
CASE
WHEN ((SUBSTR(Contact.AppellantID,0,4)) = 'ASM_') THEN 1
WHEN ((SUBSTR(Contact.AppellantID,0,4)) = 'CAN_') THEN 1
WHEN ((SUBSTR(Contact.AppellantID,0,4)) = 'AUX_') THEN 1
ELSE 0
END
) AS NB_ASSMAT,
SUM(
CASE
WHEN ((SUBSTR(Contact.AppellantID,0,4)) = 'FAM_ ') THEN 1
ELSE 0
END
) AS NB_FAMILLE,
SUM(
CASE
WHEN ((SUBSTR(Contact.AppellantID,0,4)) = 'PAR_ ') THEN 1
ELSE 0
END
) AS NB_PARENT,
LEFT(Contact.Date,4) AS ANNEE
FROM
Contact
WHERE
Contact.InfoID ='1'
GROUP BY
LEFT(Contact.Date,4)
ORDER BY
ANNEE |
Partager