Score / Character by user

0

Please login or register to vote for this query.

(click on this box to dismiss)

How much net score does each character in your answers bring you? Find out with this query ;)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP ##topX?10##
  Id AS [Post Link],
  Score,
  CreationDate,
  LEN(Body) as Length,
  round((Len(Body) / Score * 1.0), 2) as CharsPerUpvote
FROM Posts
WHERE OwnerUserId = '##UserId?0##'
   AND PostTypeId In (1,2) --questions and answers
   AND Score <> 0 -- division by 0 error!
ORDER BY CharsPerUpvote DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results