User activity in tag over time


Please login or register to vote for this query.

(click on this box to dismiss)

Unfinished query, meant to be extended to talk about top users (currently only taking top rep users)

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

select Z.[Month] [Month],Z.ouid UserName, count(Z.ouid) as cnt
select CAST(
      cast(DATEPART(YYYY, Y.CreationDate) as varchar) + '-' + cast(DATEPART(MM, Y.CreationDate) as varchar) + '-01'
      as datetime) [Month], U.DisplayName ouid
   from posts Y
      inner join posts p2  on inner join users U on
      where Y.posttypeid=2 and (p2.tags like '%##TagName?quantum-mechanics##%') 
) Z group by Z.ouid,Z.[Month] order by [Month] asc, UserName asc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results