Please login or register to vote for this query.

(click on this box to dismiss)

Русский язык Meta

Q&A for лингвистов, этимологов, и энтузиастов русского языка

SELECT *, count(*) AS count FROM (
  SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0) AS [month], 
    t.TagName as [tag]
  FROM Posts p 
    JOIN PostTags pt ON pt.PostId = p.Id
    JOIN Tags t ON t.Id = pt.TagId
  WHERE t.tagName IN ('python', 'r', 'scala')
) as X
GROUP BY [tag], month
ORDER BY [tag], month

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results