Most popular StackOverflow tags in 2021

1

Please login or register to vote for this query.

(click on this box to dismiss)

Most popular StackOverflow tags in 2021. The results of this query used in 抛砖问答(PZWD). https://pzwd.net/t/top-of-stackoverflow / https://github.com/pzwd-net/stackoverflow-queries

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

-- Most popular StackOverflow tags in 2021
SELECT
  top 100 num.TagName AS Tag,
  ROW_NUMBER() OVER (
    ORDER BY
      rate.Rate desc
  ) AS RANK,
  ROW_NUMBER() OVER (
    ORDER BY
      num.Num desc
  ) AS TotalRank,
  rate.Rate AS Questions,
  num.Num AS QuestionsTotal
FROM
  (
    SELECT
      COUNT(PostId) AS Rate,
      TagName
    FROM
      Tags,
      PostTags,
      Posts
    WHERE
      Tags.Id = PostTags.TagId
      AND Posts.Id = PostTags.PostId
      AND Posts.CreationDate < '2022-01-01'
      AND Posts.CreationDate > '2021-01-01'
    GROUP BY
      TagName
  ) AS rate
  INNER JOIN (
    SELECT
      COUNT(PostId) AS Num,
      TagName
    FROM
      Tags,
      PostTags,
      Posts
    WHERE
      Tags.Id = PostTags.TagId
      AND Posts.Id = PostTags.PostId
    GROUP BY
      TagName
    HAVING
      COUNT(PostId) > 1000
  ) AS num ON rate.TagName = num.TagName
ORDER BY
  rate.rate desc;

Enter Parameters

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