0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for biology researchers, academics, and students

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;

fork query

edited jul 19 18 anonymous

created jul 19 18 Secespitus