Posts, Answers, Comments, Favourits, and Views By Month Year, and Tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

SELECT 

  MONTH([Posts].[CreationDate]) AS PostMon,
  YEAR([Posts].[CreationDate]) AS PostYear,
  [Posts].[Tags],
  COUNT(*) as NumberOfTags,
  SUM([Posts].[AnswerCount]) AS NumberOfAnswers,
  SUM([Posts].[CommentCount]) AS NumberOfComments,
  SUM([Posts].[FavoriteCount]) AS NumberOfFavourites,
  SUM([Posts].[ViewCount]) AS NumberOfViews

FROM

  [Posts]

WHERE

  [Posts].[Tags] IS NOT NULL 

GROUP BY 

  MONTH([Posts].[CreationDate]),
  YEAR([Posts].[CreationDate]),
  [Posts].[Tags]
  
ORDER BY 

  [PostMon] DESC,
  [PostYear] DESC,
  [NumberOfTags] DESC

Enter Parameters

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