select round(u.Reputation, -3, 1), COUNT(*) from Suggeste...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select round(u.Reputation, -3, 1), COUNT(*)
from SuggestedEditVotes v
inner join SuggestedEdits s on s.Id = v.SuggestedEditId
inner join Posts p on p.Id = s.PostId
inner join Users u on u.Id = v.UserId
where (p.PostTypeId = 4
or p.PostTypeId = 5)
and s.CreationDate > '2015-1-1'
group by round(u.Reputation, -3, 1)
having round(u.Reputation, -3, 1) < 60000
order by round(u.Reputation, -3, 1) ASC

Enter Parameters

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