0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT
  p.OwnerUserId AS [User Link], 
  sum(p.ViewCount)/count(p.Id) AS ViewCountRatio
FROM Posts p
WHERE p.PostTypeId = 1 AND ViewCount > 10000
GROUP BY p.OwnerUserId
ORDER BY sum(p.ViewCount)/count(p.Id) DESC

fork query

edited feb 7 12

created feb 7 12 anonymous