TicketsPerMonth

From SMT-X
Jump to: navigation, 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)