Top answerers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

SELECT COUNT(*) AS AmountOfAnswers,
       USERS.DisplayName AS DisplayName,
       (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