Asking average statistics

0

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 asking_average as (
  select OwnerUserId, 
         (count(*) 
          - count(ClosedDate) 
          - count(case when Score < 0 then 1 end)
         )/(count(*)*1.0) AA,
         count(*) N
  from Posts
  where PostTypeId = 1
  group by OwnerUserId
),

AA_bins as (
  select round(AA, 1) bin
  from asking_average aa
  where N >= 5
        and AA >=0
)
  
select bin, count(*)
from AA_bins
group by bin
order by bin

Enter Parameters

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