SELECT Tags.TagName, DATEPART(month, Posts.CreationDate),...

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT
    Tags.TagName,
    DATEPART(month, Posts.CreationDate),
    DATEPART(year, Posts.CreationDate),
    COUNT(Posts.Id) as 'tag-count',
    COUNT(Posts.AcceptedAnswerId) as 'countAcceptedAnswers'
FROM
    Tags
    INNER JOIN PostTags ON PostTags.TagId = Tags.id
    INNER JOIN Posts ON Posts.Id = PostTags.PostId
WHERE
Tags.TagName like '%kubernetes%'
GROUP BY
    Tags.TagName,
    DATEPART(month, Posts.CreationDate),
    DATEPART(year, Posts.CreationDate)
ORDER BY 3 desc, 2 desc, 4 desc

Enter Parameters

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