SQL Query to find issue count by Issue Types between dates

Rob B_jadbuo

I need a query so i can find out how many issues have been created grouped by Issue Types and this is only in the last 12 months.

Example Output:

Issue Type A | 146
Issue Type B | 16
Issue Type C | 118

Thanks

 

John Pisani

I went searching myself and found the question but no reply. Better late than never.

This example is for SQL Server. 

SELECT it.pname AS 'Issue Type', it.pstyle AS 'Type', COUNT(i.ID) AS 'Count'
FROM issuetype it
LEFT JOIN jiraissue i ON it.ID = i.issuetype
WHERE i.CREATED > dateadd(month,datediff(month,0,getdate())-12,0)
GROUP BY it.pname, it.pstyle
ORDER BY COUNT(i.ID) DESC