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 TOP 5 
  p.OwnerUserId as [User Link], 
  p.Id as [Post Link], 
  max(p.ViewCount) as ViewCount
FROM Posts p
WHERE p.PostTypeId = 1
GROUP BY p.OwnerUserId, p.Id
ORDER BY max(p.ViewCount) desc

Enter Parameters

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