Post Score Efficiency

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

select
   ROW_NUMBER() OVER (ORDER BY avg (1.0 * Score) DESC) AS Rank,
   OwneruserId as [User Link],
   PostTypeId,
   avg (1.0 * Score) as [Avg],
   Count(*) as [Count]
from Posts
where PostTypeId in (1, 2)
  and OwnerUserId > 1
group by OwnerUserId, PostTypeId
having count (*) > 10
order by avg (1.0 * Score) desc

Enter Parameters

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