Question Count over time by tag comparison

0

Please login or register to vote for this query.

(click on this box to dismiss)

Plots total questions over time or total score over time, comparing up to 4 tags. Reference: http://meta.stackoverflow.com/q/260570/331508

Stack Overflow

Q&A for professional and enthusiast programmers

-- Tag1: Tag name (lowercase) or 'NA' (uppercase) "Enter a tag name or uppercase NA or a single space"
-- Tag2: Tag name (lowercase) or 'NA' (uppercase) "Enter a tag name or uppercase NA or a single space"
-- Tag3: Tag name (lowercase) or 'NA' (uppercase) "Enter a tag name or uppercase NA or a single space"
-- Tag4: Tag name (lowercase) or 'NA' (uppercase) "Enter a tag name or uppercase NA or a single space"
DECLARE @Tag1 varchar(255)  = ##Tag1:string##;
DECLARE @Tag2 varchar(255)  = ##Tag2:string##;
DECLARE @Tag3 varchar(255)  = ##Tag3:string##;
DECLARE @Tag4 varchar(255)  = ##Tag4:string##;

WITH QuestStatsByMonth  AS (
    SELECT      DATEADD (month, DATEDIFF (month, 0, q.CreationDate), 0)  AS [Month],
    t.TagName,
    COUNT (q.Id)                AS NumQuests

    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       IN (@Tag1, @Tag2, @Tag3, @Tag4)

    GROUP BY    DATEADD (month, DATEDIFF (month, 0, q.CreationDate), 0),
                t.TagName
)
SELECT
    q.[Month],
    q.TagName AS [Tag],
    SUM (q.NumQuests) AS Questions
FROM        QuestStatsByMonth   q
GROUP BY    q.[Month], q.TagName
ORDER BY    q.TagName, q.[Month]

Enter Parameters

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