test

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 top 2000 
  OwnerUserId [User Link], 
  Reputation,
  round(avg(cast(Score as real)),2) as [Avg Score],
  count(*) as [# Questions], 
  sum(case when Score < 0 then 1 else 0 end) as [#Negative Score Q]
from Posts 
join Users u on u.Id = OwnerUserId 
where PostTypeId = 1
group by OwnerUserId, Reputation
having count(*) >= ##MinQuestions##
order by [# Questions] desc, [Avg Score] desc

Enter Parameters

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