0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

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