Most and least dangerous tags to answer (among the tags with 1000+ questions)

0

Please login or register to vote for this query.

(click on this box to dismiss)

This query shows the number of upvotes, downvotes and D/U ratio for the answers to the most common tags

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

-- Most and least dangerous tags to answer (among the tags with 1000+ questions)
-- This query shows the number of upvotes, downvotes and D/U ratio for the answers to the most common tags

SELECT Tags.TagName, (
    SELECT COUNT(*)
    FROM Posts
    JOIN PostTags ON Posts.Id = PostTags.PostId
    WHERE Posts.PostTypeId = 1 AND PostTags.TagId = Tags.Id
  ) AS Questions, (
    SELECT COUNT(*)
    FROM Posts
    JOIN PostTags ON Posts.Id = PostTags.PostId
    WHERE Posts.PostTypeId = 1 AND PostTags.TagId = Tags.Id AND Posts.AcceptedAnswerId > 0
  ) AS [Questions With Accepted Answers]
  FROM Tags
  ORDER BY Questions DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results