1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

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

fork query

edited sep 6

created sep 6 peterh - PLEASE DELETE THIS ACCOUNT