Top answerers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computer Graphics

Q&A for computer graphics researchers and programmers

SELECT USERS.DisplayName AS DisplayName, 
       COUNT(*) AS AmountOfAnswers,
       (ROW_NUMBER() OVER (ORDER BY Count(*) DESC) * 100.0) / 9776.0 AS Percentage 
  FROM POSTS,
       USERS
 WHERE POSTS.OwnerUserId = USERS.Id
   AND POSTS.PostTypeId = 2
 GROUP BY USERS.DisplayName
 ORDER BY 2 DESC;

Enter Parameters

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