Highest question to view ratio by user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

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

SELECT
  p.OwnerUserId AS [User Link], 
  sum(p.ViewCount) AS [Total Views],
  count(p.Id) AS [Total Famous Questions],
  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) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results