select u.id , count(rejectiondate) reject , count(approva...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chess

Q&A for serious players and enthusiasts of chess

select u.id
     , count(rejectiondate) reject
     , count(approvaldate)  approve
     , (count(approvaldate) 
      / (convert(decimal, count(*))) * 100.0) [rate] 
from suggestededits se
inner join users u on u.id = se.owneruserid
where u.reputation between 1750 and 2000
group by u.id
having count(approvaldate) > 0
and count(*) > 100 
order by [rate] desc

Enter Parameters

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