0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT * FROM

 

  (SELECT

 

    YEAR(Posts.CreationDate) as CreationYear,

    --MONTH(Posts.CreationDate) as CreationMonth,

    TagName,

    COUNT(Posts.Id) as PostCount,

    --RANK() OVER (PARTITION BY YEAR(Posts.CreationDate), MONTH(Posts.CreationDate) ORDER BY COUNT(PostId) DESC) AS Rank

    RANK() OVER (PARTITION BY YEAR(Posts.CreationDate) ORDER BY COUNT(PostId) DESC) AS Rank

 

  FROM

 

    Tags, PostTags, Posts, Users

 

  WHERE

 

    Tags.Id = PostTags.TagId and

    Posts.Id = PostId and

    Posts.OwnerUserId = Users.Id

    --and (LOWER(Users.Location) like '%brazil' or LOWER(Users.Location) like '%brasil')

 

  --GROUP BY YEAR(Posts.CreationDate), MONTH(Posts.CreationDate), TagName)
  GROUP BY YEAR(Posts.CreationDate), TagName)

  AS TagPostRankings

 

WHERE

  Rank <= 10 AND

  CreationYear >= 2010
  
  --CreationYear = 2023

 

--ORDER BY CreationYear, CreationMonth, Rank

ORDER BY CreationYear, Rank

fork query

edited mar 2

created mar 2 godz