Count the number of Deputy with less than 10K reputation

Please login or register to vote for this query.

(click on this box to dismiss)

Compute how much user with deputy badge does not have access to moderation tool. Also show the average reputation of those users. Also show the average reputation of those users. Parameter used to filter on the minimum global reputation

Q&A for programmers

-- Count the number of Deputy with less than 10K reputation
-- Compute how much user with deputy badge does not have access to moderation tool. Also show the average reputation of those users. Also show the average reputation of those users.

Select count(*) as Total, avg(reputation) as avergage_reputation
from Badges
inner join users on users.id = Badges.userid
where Name like 'Deputy'
and reputation < 10000
and Reputation >= ##Rep##;

created may 20 11