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
| SELECT cal.cal_month AS [month]
, cal.cal_year AS [year]
, pri.pr_name AS [priority]
, pri.pr_sort_seq
, count(1) AS [count]
FROM bugs AS bug
INNER JOIN
priorities AS pri
ON bug.bg_priority = pri.pr_id
LEFT OUTER JOIN
releases AS rel
ON bug.bg_version = rel.rl_version
RIGHT OUTER JOIN
calendrier AS cal
ON cal.cal_date = rel.rl_date
WHERE bug.bg_category = 2
AND cal.cal_year BETWEEN 2005 AND EXTRACT(YEAR FROM CURRENT_DATE)
GROUP BY cal.cal_year
, cal.cal_month
, pri.pr_sort_seq
, pri.pr_name
ORDER BY cal.cal_year
, cal.cal_month
, pri.pr_sort_seq
; |
Partager