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