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

-- Total Users
-- A specific number of users
declare @allPosts decimal(15,5) 
SELECT @allPosts = cast(COUNT(*) as decimal(15,5) ) FROM posts

SELECT  CAST(SUM(k) as decimal (15,5)) / @allPosts * 100
FROM (
SELECT TOP 10 PERCENT OwnerUserID , count(id) k
FROM Posts p
WHERE OwnerUserID > 0
GROUP BY OwnerUserID
ORDER BY count(id) desc ) T

view current version

edited jun 21 12

created jun 21 12 conradfrix