How often does a user accept an answer without upvoting it?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Useful for people trying to achieve Tenacious and Unsung Hero badges

Web Applications

Q&A for power users of web applications

-- How often does a user accept an answer without upvoting it?
-- Useful for people trying to achieve Tenacious and Unsung Hero badges

DECLARE @UserId int = ##AskerId##

SELECT
  (CAST(Count(Posts.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS UnvotedAcceptPercentage
FROM 
  Posts
WHERE
    Posts.OwnerUserId = @UserId
  AND
    Posts.PostTypeId = 11
  AND
    Posts.AcceptedAnswerId NOT IN (
       SELECT 
         Votes.Id
       FROM
         Votes
       WHERE
           Votes.UserID = @UserId
         AND
           Votes.VoteTypeId = 2
    )

Enter Parameters

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