Questions by week by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
  DATEADD(DAY, 0, DATEADD(DAY,-DATEPART(DW,CAST('1/1/' + cast(Year as varchar) AS Date))+2,DATEADD(WK,Week-1,CAST('1/1/' + cast(Year as varchar) AS Date)))) as Date,
  Questions
  FROM (
    SELECT DATEPART(YYYY, Posts.CreationDate) Year, DATEPART(WW, Posts.CreationDate) as Week, COUNT(*) as Questions
      FROM Posts 
      WHERE PostTypeId = 1 AND Id in (
        SELECT PostId FROM PostTags WHERE TagId in (
          SELECT Id FROM Tags WHERE TagName = 'typescript'
        )
      )
      GROUP BY DATEPART(YYYY, Posts.CreationDate), DATEPART(WW, Posts.CreationDate)
    ) as x
    
  order by 1

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results