0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers and students of the Korean language

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) 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))
  
  --GROUP BY YEAR(Posts.CreationDate), TagName)

  AS TagPostRankings

 

WHERE

  --Rank <= 20 AND

  --CreationYear >= 2018
  
  CreationYear = 2023

 

ORDER BY CreationYear, CreationMonth

--ORDER BY CreationYear, Rank

fork query

edited mar 2

created mar 2 godz