Longest answers by user with votes and chars-per-vote


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

  p.id as [Post Link],
  Len(p.Body) AS Length,
  Score AS Votes,
  Convert(int, Len(p.Body)/(1+Score)) AS Cost,
  Convert(int, Len(p.Body) * (1+Score)/1000) AS Punch,
  Convert(int, Len(p.Body) * (1+Score)/1000)/Convert(int, Len(p.Body)/(1+Score)) AS "PunchCost"
FROM Users u, Posts p 
WHERE p.OwnerUserId = ##UserId##
  AND u.Id = p.OwnerUserId
  AND p.PostTypeId = 2
  AND Score >= 0

ORDER BY PunchCost DESC, Length DESC, Cost DESC, Punch DESC, Votes DESC

Enter Parameters

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