Users who've posted at least ten useful answers in the last 30 days, ordered by % helpful

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select top 100 OwnerUserId as [User Link], 
round(count(case when Score > 0 then 1 else null end) * 100.0 / count(*), 2) as "Helpful %"
  
from Posts
where PostTypeId=2
and CreationDate > getdate() - 30
group by OwnerUserId
having count(*) >= 10
order by round(count(case when Score > 0 then 1 else null end) * 100.0 / count(*), 2) desc
fork query

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
Results Messages Graph Execution Plan
Download CSV Download XML
:records rows returned in :time ms:cached