แท็ก PresenceInsights (1 แท็กเท่านั้น) ผลรวมรายเดือน NLB ไม่จำเป็นต้องใช้ตารางทั้งหมด
PresenceInsights tag (1 tag only); monthly totals NLB.It is not neccessary to use all the tables.
 PostTags:  PostId [ number]  TagId [ number] 
SELECT DATEADD(mm, (YEAR(Posts.CreationDate) - 1900) * 12 + MONTH(Posts.CreationDate) - 1, 0) AS Month, Tags.TagName, COUNT(*) AS Questions FROM Tags LEFT JOIN PostTags ON PostTags.TagId = Tags.Id LEFT JOIN Posts ON Posts.Id = PostTags.PostId LEFT JOIN PostTypes ON PostTypes.Id = Posts.PostTypeId WHERE Tags.TagName IN ('bluemix-mobile-services') AND PostTypes.Name = 'Question' AND CreationDate > '1/01/2012 12:00AM' GROUP BY YEAR(Posts.CreationDate), MONTH(Posts.CreationDate), Tags.TagName ORDER BY YEAR(Posts.CreationDate), MONTH(Posts.CreationDate), Tags.TagName