0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

-- Posts in a month
Select u.DisplayName as Posts, Count(u.DisplayName) 
From Posts p Inner Join Users u On p.OwnerUserId = U.id
Where p.OwnerUserId in (2142626, 3947, 1084691, 17328, 9778623)
  AND p.PostTypeId = 2
  AND Year(p.CreationDate) = 2013
  AND Month(p.CreationDate) = 10
Group By u.DisplayName
;


-- Top tags
Select t.TagName as TagsInQuestions, Count(t.TagName)
From Posts p 
  Inner Join PostTags pt on p.Id = pt.PostId
  Inner Join Tags t on pt.TagId = t.Id
Where p.OwnerUserId in (2142626, 3947, 1084691, 17328)
  AND p.PostTypeId = 1
  AND Year(p.CreationDate) = 2013
  AND Month(p.CreationDate) = 10
Group By t.TagName
Order By Count(t.TagName) desc
;
Select t.TagName as TagsInAnswers, Count(t.TagName)
From Posts p 
  Inner Join PostTags pt on p.ParentId = pt.PostId
  Inner Join Tags t on pt.TagId = t.Id
Where p.OwnerUserId in (2142626, 3947, 1084691, 17328)
  AND p.PostTypeId = 2
  AND Year(p.CreationDate) = 2013
  AND Month(p.CreationDate) = 10
Group By t.TagName
Order By Count(t.TagName) desc
;

fork query

edited aug 16 19 anonymous

created nov 12 13 Mark McDonald