Active users that:
- have asked at least 3 questions
- received at least 1 answer per question
- have never accepted an answer
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