Q&A about the site for gardeners and landscapers
select dateadd(month, datediff(month, 0, CreationDate), 0) as Mnth, avg(datediff(mi, CreationDate, ClosedDate)) as AvgTimeToClose from PostsWithDeleted where ClosedDate is not null and tags like '%identify%' group by dateadd(month, datediff(month, 0, CreationDate), 0) order by dateadd(month, datediff(month, 0, CreationDate), 0)