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 |
