Question score by number asked

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for 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, 
       --max(score),
       --count(*),
       avg(score) avg_score
from user_questions
where number_asked <= ##limit?50##
      --and score > 0
group by number_asked

Enter Parameters

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