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 */