Graph of answer quality and number

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

select 
   *,
   count(*)
from (
  select 
    p.OwnerUserId as [User Link], 
    u.Reputation,
    round(avg(cast(p.Score as real)),2) as [Avg Score], 
    count(*) as [# Questions]
  from Posts p
  join Users u on u.Id = p.OwnerUserId
  where p.posttypeid = 2 and
    p.communityowneddate is null and
    p.closeddate is null
  group by u.Reputation, p.OwnerUserId
) as X
group by [# Questions] , [Avg Score], Reputation, [User Link]
order by [Avg Score] desc, [# Questions] desc

Enter Parameters

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