0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

SELECT 
    Tags.TagName,
    COUNT(PostTags.PostId)
FROM
    Tags
    INNER JOIN PostTags ON Tags.Id = PostTags.TagId
    INNER JOIN Posts ON Posts.Id = PostTags.PostId
WHERE
    Posts.PostTypeId = 1 -- Only consider questions
GROUP BY 
    Tags.TagName;

fork query

edited aug 14

created aug 14 anonymous