0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited apr 9 14

created apr 9 14 Jon "not doe" Ericson