Permissions Total User Distribution

0

Please login or register to vote for this query.

(click on this box to dismiss)

Personal Finance and Money

Q&A for people who want to be financially literate

SELECT COUNT(Id) AS [Active User Count],
CASE 
   WHEN Reputation >= 3000 THEN '1. VoteClose (3000+)'
   WHEN Reputation >= 2000 THEN '2. Editing (2000+)'
   WHEN Reputation >= 1000 THEN '3. Established (1000+)'
   WHEN Reputation >= 500 THEN '4. Late/First Review (500+)'
   WHEN Reputation >= 250 THEN '5. Self Close (250+)'
   WHEN Reputation >= 15 THEN '6. Flag (15+)'
   WHEN Reputation < 15 THEN '7. Nothing (14-)'
 END AS [Privs]
FROM Users
-- WHERE LastAccessDate > DateAdd(d, -30, GETDATE())
GROUP BY CASE 
   WHEN Reputation >= 3000 THEN '1. VoteClose (3000+)'
   WHEN Reputation >= 2000 THEN '2. Editing (2000+)'
   WHEN Reputation >= 1000 THEN '3. Established (1000+)'
   WHEN Reputation >= 500 THEN '4. Late/First Review (500+)'
   WHEN Reputation >= 250 THEN '5. Self Close (250+)'
   WHEN Reputation >= 15 THEN '6. Flag (15+)'
   WHEN Reputation < 15 THEN '7. Nothing (14-)'
 END
 ORDER BY Privs ASC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results