Monthly [Perl6] tag questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

WITH QuestionsByMonth  AS (
SELECT DATEADD (month, DATEDIFF (month, 0, q.CreationDate), 0) AS [Month],
          q.Id AS id

    FROM        Posts           q
    INNER JOIN  PostTags        pt
    ON          q.Id            = pt.PostId
    INNER JOIN  Tags            t
    ON          t.Id            = pt.TagId

    WHERE       q.PostTypeId    = 1
    AND         t.TagName       = 'perl6'

)
SELECT
q.[Month], COUNT(q.id) AS Qs

FROM        QuestionsByMonth   q
GROUP BY    q.[Month]
ORDER BY    q.[Month]

Enter Parameters

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