Tag Question Timeline

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
  CONCAT(
    datepart(year,posts.CreationDate), '/',
    datepart(month,posts.CreationDate), '/',
    datepart(day,posts.CreationDate) 
  )as 'Day',
  COUNT(*) as 'Total'
FROM PostTags as pt
JOIN POSTS as posts
  ON pt.PostId = posts.Id
JOIN Tags as tags
  ON pt.TagId = tags.Id
WHERE tags.TagName = ##TagName:string##
GROUP BY 
  datepart(year,posts.CreationDate),
  datepart(month,posts.CreationDate),
  datepart(day,posts.CreationDate)
ORDER BY
  datepart(year,posts.CreationDate) ASC,
  datepart(month,posts.CreationDate) ASC,
  datepart(day,posts.CreationDate) ASC

Enter Parameters

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