Interesting recent questions by users with high accept rates

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

declare @start date = dateadd(week, -1, getdate())

select
  p.Id as [Post Link], p.Score, u.Id as [User Link], u.Reputation
from Posts as p
  join Users as u
    left join Posts as q
    on q.OwnerUserId = u.Id
  on u.Id = p.OwnerUserId
where p.PostTypeId = 1 -- question
and p.CreationDate >= @start
and p.Score > 2
and p.AcceptedAnswerId is null

group by
 p.Id
,p.Score
,p.Title
,u.Id
,u.Reputation
having sum(iif(q.AcceptedAnswerId is null, 0.0, 1.0)) > 2
and sum(iif(q.AcceptedAnswerId is null, 0.0, 1.0)) / nullif(count(q.Id),0) > .5

Enter Parameters

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