Post Score Efficiency


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

   ROW_NUMBER() OVER (ORDER BY avg (1.0 * Score) DESC) AS Rank,
   OwneruserId as [User Link],
   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

Switch to meta site
loading Hold tight while we fetch your results