Interesting recent questions by users with high accept rates


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())

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
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

Switch sites:
loading Hold tight while we fetch your results