0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

SELECT top_tags,
ROW_NUMBER() OVER(PARTITION BY year ORDER BY max_views DESC) AS row_num,
max_views,
year,
username
FROM
  (SELECT tags AS top_tags,
  YEAR(creationdate) AS year,
  MAX(viewCount) OVER(PARTITION BY YEAR(creationdate)) as max_views,
  OwnerDisplayName AS username
  FROM Posts) AS subquery
 WHERE top_tags IS NOT NULL;

view current version

edited mar 27 23

created mar 27 23 David1platt