Has the most questions with only very few accept vote

1

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

SELECT TOP 100
  OwnerUserId AS [User Link],
  COUNT(*) - COUNT(AcceptedAnswerId) AS HasNoAccept,
  COUNT(AcceptedAnswerId) AS HasAccepted
FROM Posts
WHERE
  PostTypeId = 1
  AND
  OwnerUserId > 0
  AND
  CommunityOwnedDate IS NULL
  AND
  AnswerCount > 0
GROUP BY OwnerUserId
HAVING COUNT(*) > ##MaxAcceptRatio:int?10## * COUNT(AcceptedAnswerId)
ORDER BY HasNoAccept DESC, OwnerUserId

Enter Parameters

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