Unaccepters

0

Please login or register to vote for this query.

(click on this box to dismiss)

Active users that: - have asked at least 3 questions - received at least 1 answer per question - have never accepted an answer

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Count(*) as "Number of questions", Reputation, OwnerUserId AS [User Link], LastAccessDate as "Last seen"
FROM Posts, Users
WHERE PostTypeId = 1
  and OwnerUserId = Users.Id
--and reputation > 50
  and CONVERT(date, LastAccessDate) > '20160101'
group by OwnerUserId, DisplayName, reputation, LastAccessDate
having (count(AcceptedAnswerId) = 0 
    and count(*) > 5 
    and Count(CASE WHEN AnswerCount > 0 THEN 1 ELSE null END) > 1 )
    Order By Count(*) DESC

Enter Parameters

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