Count the number of Deputy with less than 10K reputation

0

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

Cooking Meta

Q&A about the site for professional and amateur chefs

-- 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##;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached