SELECT floor(2*LOG10(Users.Reputation)+1)/2, count(*), SI...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
  floor(2*LOG10(Users.Reputation)+1)/2, 
  count(*),
  SIGN(ISNULL(Posts.AcceptedAnswerId, 0))
FROM Posts
INNER JOIN Users 
   ON Users.Id=Posts.OwnerUserId
WHERE Posts.AnswerCount > 0
GROUP BY floor(2*LOG10(Users.Reputation)+1)/2, SIGN(ISNULL(Posts.AcceptedAnswerId, 0))
ORDER BY floor(2*LOG10(Users.Reputation)+1)/2 + 100*SIGN(ISNULL(Posts.AcceptedAnswerId, 0))

Enter Parameters

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