0

Please login or register to vote for this query.

(click on this box to dismiss)

Just get a feel for the question count based on some FP tags. This would be better if a multi-value parameter could be provided rather than pre-defined tag names.

Q&A for amateur radio enthusiasts

SELECT sub.Month,
         Tags.TagName,
         count(*) 'Count'
FROM (((
    (SELECT ( cast(DATEPART(YYYY,
         Posts.CreationDate) AS varchar) + '-' 
         + cast(DATEPART(MM, Posts.CreationDate) AS varchar) + '-01' ) AS 'Month', Posts.id
    FROM Posts ) sub
    INNER JOIN Posts
        ON Posts.id = sub.id)
    INNER JOIN PostTags
        ON PostTags.PostId = Posts.id)
    INNER JOIN Tags
        ON Tags.Id = PostTags.TagId
            AND Tags.TagName IN ('scala', 'haskell', 'eta', 'eta-lang', 'kotlin'))
GROUP BY  TagName, sub.Month
ORDER BY  sub.Month desc, Count desc

fork query

edited oct 6 17

created oct 5 17 Mark.Mynsted