1 2 3 4 5 6 7 8 9 10 11
| SELECT BG_SEVERITY SEVERITE, 'Anomalie' BG_TYPE, EXTRACT(YEAR FROM BG_DETECTION_DATE) ANNEE, EXTRACT(MONTH FROM BG_DETECTION_DATE) MOIS, COUNT(*) EFF
FROM BUG
WHERE BG_USER_TEMPLATE_05 LIKE '%Anomalie%'
GROUP BY BG_SEVERITY, EXTRACT(YEAR FROM BG_DETECTION_DATE), EXTRACT(MONTH FROM BG_DETECTION_DATE)
ORDER BY BG_SEVERITY, EXTRACT(YEAR FROM BG_DETECTION_DATE), EXTRACT(MONTH FROM BG_DETECTION_DATE)
UNION
SELECT BG_SEVERITY SEVERITE, 'évolution' BG_TYPE, EXTRACT(YEAR FROM BG_DETECTION_DATE) ANNEE, EXTRACT(MONTH FROM BG_DETECTION_DATE) MOIS, COUNT(*) EFF
FROM BUG
WHERE BG_USER_TEMPLATE_05 LIKE '%évolution%'
GROUP BY BG_SEVERITY, EXTRACT(YEAR FROM BG_DETECTION_DATE), EXTRACT(MONTH FROM BG_DETECTION_DATE)
ORDER BY BG_SEVERITY, EXTRACT(YEAR FROM BG_DETECTION_DATE), EXTRACT(MONTH FROM BG_DETECTION_DATE) |
Partager