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
|
SELECT
COUNT(DISTINCT RFC_NUMBER) AS nbTickets
,CASE
WHEN DEPARTMENT_FR LIKE 'TOTO%' THEN 'TOTO'
ELSE DEPARTMENT_FR
END AS Departement
,MONTH(SUBMIT_DATE_UT) AS mois
,YEAR(SUBMIT_DATE_UT) AS annee
FROM
[50005].SD_REQUEST
,[50005].AM_DEPARTMENT
WHERE
SD_REQUEST.DEPARTMENT_ID = AM_DEPARTMENT.DEPARTMENT_ID
AND YEAR(SUBMIT_DATE_UT)='2013'
AND (DEPARTMENT_FR LIKE 'TOTO%' OR DEPARTMENT_FR LIKE 'TATA')
GROUP BY
CASE
WHEN DEPARTMENT_FR LIKE 'TOTO%' THEN 'TOTO'
ELSE DEPARTMENT_FR
END,
YEAR(SUBMIT_DATE_UT),
MONTH(SUBMIT_DATE_UT)
ORDER BY Departement,YEAR(SUBMIT_DATE_UT),MONTH(SUBMIT_DATE_UT) |
Partager