Azure threads average Day To Answer by month

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフロー

プログラマーとプログラミングに熱心な人々のための質問と回答

SELECT COUNT(*) as AnsweredVolume,
SUM(DATEDIFF(minute, P.CreationDate, P1.CreationDate)) as TotalTime,
DATEPART(year, P.CreationDate) as [Year], 
DATEPART(month, P.CreationDate) as Month
FROM [Posts] as P
inner join [Posts] as P1 on P.AcceptedAnswerId = P1.Id 
WHERE (P.Tags like '%<azure%'
or P.Tags like '%<windows-azure%'
or P.Tags like '%<sql-azure>%'
or P.Tags like '%<tfs-azure>%'
or P.Tags like '%<servicebus>%'
or P.Tags like '%<acs>%'
or P.Tags like '%<accesscontrolservice>%') 
and P.PostTypeId = 1 
and P.CommunityOwnedDate is null and P.ClosedDate is null
and P.AcceptedAnswerId > 0
GROUP by DATEPART(YEAR, P.CreationDate), DATEPART(MONTH, P.CreationDate)
ORDER by [Year], Month

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results