0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT
    YEAR(CreationDate) AS Year,
    COUNT(DISTINCT TagName) AS TagCount
FROM
    Tags
JOIN
    PostTags ON Tags.Id = PostTags.TagId
JOIN
    Posts ON PostTags.PostId = Posts.Id
GROUP BY
    YEAR(CreationDate)
ORDER BY
    Year;

fork query

edited sep 12

created may 8 18 anonymous