How many users can do x?

0

Please login or register to vote for this query.

(click on this box to dismiss)

How many users have permissions to do special things on the site.

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

-- How many users can do x?
-- How many users have permissions to do special things on the site.

create table #RepCohorts
(
 Ability text,
 MinRep int
)

insert into #RepCohorts (Ability, MinRep)
select 'Registered', 0 union all
select 'Flag offensive', 15 union all
select 'Upvote', 15 union all
select 'Comment', 50 union all
select 'Downvote', 100 union all
select 'Edit CW', 100 union all
select 'Reduced avertising', 200 union all
select 'Close/re-open/migrate own questions', 250 union all
select 'Retag questions', 500 union all
select 'See total upvotes/downvotes', 1000 union all
select 'Create tags', 1500 union all
select 'Edit non-CW posts', 2000 union all
select 'Close/re-open/migrate questions', 3000 union all
select 'Dummy', 5000 union all
select 'Mod tools', 10000

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results