ปริมาณเธรด Azure พร้อมคำตอบที่ยอมรับเป็นรายเดือน ไม่จำเป็นต้องใช้ตารางทั้งหมด
Azure thread volume with accepted answers by month.It is not neccessary to use all the tables.
 PendingFlags:  Id [ number]  FlagTypeId [ number]  PostId [ number]  CreationDate [ time]  CloseReasonTypeId [ number]  CloseAsOffTopicReasonTypeId [ number]  DuplicateOfQuestionId [ number]  BelongsOnBaseHostAddress [ text] 
SELECT COUNT(*) AS AnsweredVolume, TIME_TO_STR(P.CreationDate, '%Y') AS "year", TIME_TO_STR(P.CreationDate, '%m') AS Month FROM Posts AS P WHERE (Tags LIKE '%<azure%' OR Tags LIKE '%<windows-azure%' OR Tags LIKE '%<sql-azure>%' OR Tags LIKE '%<tfs-azure>%' OR Tags LIKE '%<servicebus>%' OR Tags LIKE '%<acs>%' OR Tags LIKE '%<accesscontrolservice>%') AND PostTypeId = 1 AND CommunityOwnedDate IS NULL AND ClosedDate IS NULL AND AcceptedAnswerId > 0 GROUP BY TIME_TO_STR(P.CreationDate, '%YEAR'), TIME_TO_STR(P.CreationDate, '%-mONT%-H') ORDER BY 'year', Month