0

Please login or register to vote for this query.

(click on this box to dismiss)

How many users have what privileges on graduated SE 2.0 sites.

Q&A for anime and manga fans

-- How many users can do x?
-- How many users have what privileges on graduated SE 2.0 sites.

-- Data from http://electronics.stackexchange.com/privileges/
-- Date: November 05, 2011
-- Based on http://data.stackexchange.com/stackoverflow/s/203/how-many-users-can-do-x

create table #RepCohorts
(
 Ability text,
 MinRep int
)

insert into #RepCohorts (Ability, MinRep)

select 'registered',                        0 union all
select 'create posts',                      1 union all
select 'participate in meta',               5 union all
select 'remove new user restrictions',     10 union all
select 'create wiki posts',                15 union all
select 'vote up',                          15 union all
select 'flag posts',                       15 union all
select 'talk in chat',                     20 union all
select 'comment everywhere',               50 union all
select 'set bounties',                     75 union all
select 'edit community wiki',             100 union all
select 'create chat rooms',               100 union all
select 'vote down',                       150 union all
select 'view close votes',                250 union all
select 'create tags',                     300 union all
select 'retag questions',                 500 union all
select 'established user',               1000 union all
select 'create gallery chat rooms',      1000 union all
select 'edit questions and answers',     2000 union all
select 'create tag synonyms',            2500 union all
select 'cast close and reopen votes',    3000 union all
select 'approve tag wiki edits',         5000 union all
select 'access to moderator tools',     10000 union all
select 'protect questions',             15000 union all
select 'trusted user',                  20000
                                          

select
 rc.Ability,
 rc.MinRep,
 (
  select count(u.Id)
  from Users u
  where u.Reputation >= rc.MinRep
 ) as UserCount
from #RepCohorts rc
order by rc.MinRep desc

fork query

created nov 5 11 reemrevnivek