TicketsPerMonth

From SMTX Wiki
Jump to navigation Jump to search

SELECT YEAR(DateStarted) as 'Year', MONTH(DateStarted) as 'Month', COUNT(*) as 'Total' FROM [ProcessInstance] GROUP BY YEAR(DateStarted), MONTH(DateStarted) HAVING YEAR(DateStarted)>=2016 ORDER BY YEAR(DateStarted), MONTH(DateStarted)