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
     , convert(decimal, count(rejectiondate)) 
     / count(approvaldate) [ratio] 
from suggestededits se
inner join users u on u.id = se.owneruserid
where u.reputation < 2000
group by u.id
having count(approvaldate) > 0

Enter Parameters

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