Which main tags correlates the most with meta downvoting

1

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

WITH TagScores AS (
  SELECT
    Posts.OwnerUserId AS UserId,
    PostTags.TagId,
    SUM(Posts.Score) AS Score
  FROM
    StackOverflow.dbo.Posts,
    StackOverflow.dbo.PostTags,
    StackOverflow.dbo.Tags
  WHERE
    Posts.ParentId = PostTags.PostId
    AND
    PostTags.TagId = Tags.Id
    AND
    Tags.Count >= ##MinTagCount:int?100##
  GROUP BY Posts.OwnerUserId, PostTags.TagId
  HAVING SUM(Posts.Score) >= ##MinMainTagScore:int?10##
),
MetaUpRatio AS (
  SELECT
    Id AS UserId,
    1.0 * UpVotes / (UpVotes + DownVotes) AS Ratio
  FROM
    [StackOverflow.Meta].dbo.Users
  WHERE
    UpVotes >= ##MinMetaUps:int?10##
    AND
    DownVotes >= ##MinMetaDowns:int?10##
)
SELECT
  MIN(Tags.TagName) AS TagName,
  AVG(MetaUpRatio.Ratio) AS AvgMetaUpRatio
FROM TagScores, MetaUpRatio, StackOverflow.dbo.Tags
WHERE
  TagScores.UserId = MetaUpRatio.UserId
  AND
  TagScores.TagId = Tags.Id
GROUP BY TagScores.TagId
HAVING COUNT(*) > ##MinMetaUsersForMainTag:int?10##
ORDER BY AvgMetaUpRatio

Enter Parameters

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