SELECT year, post_view_count FROM (SELECT OwnerDisplayName,

0

Please login or register to vote for this query.

(click on this box to dismiss)

Operations Research Meta

Q&A about the site for operations research and analytics professionals, educators, and students

SELECT
year,
post_view_count
FROM
  (SELECT
  OwnerDisplayName,
  YEAR(creationdate) AS year,
  MAX(MAX(viewCount)) OVER(PARTITION BY YEAR(creationdate)) AS post_view_count,
  ROW_NUMBER() OVER( ORDER BY MAX(viewCount)) AS max_views 
  FROM Posts
  Group By YEAR(creationdate), OwnerDisplayName
  ) AS subquery
WHERE max_views = 1
ORDER BY year;

--count 3009681*/

/*SELECT TOP 15
MAX(viewcount) num_views, 
OwnerDisplayName,
Title,
YEAR(creationdate)
FROM Posts
GROUP BY Title, YEAR(creationdate), OwnerDisplayName
HAVING YEAR(creationdate) BETWEEN 2008 AND 2022 
ORDER BY num_views DESC
*/

Enter Parameters

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