Question score by number asked


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

with user_questions as (
  select OwnerUserId, 
         count(*) number_asked, 
         avg(Score*1.0) score
  from Posts
  where PostTypeId = 1
        and OwnerUserId is not null
  group by OwnerUserId

select number_asked, 
       --min(score) min_score, 
       avg(score) avg_score
from user_questions
where number_asked <= ##limit?50##
      --and score > 0
group by number_asked

Enter Parameters

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