0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

select a.owneruserid,
count(*)-4*Sum(case when a.score = 0 then 1 else 0 end)/3 as MoreNeeded
from posts q inner join posts a
on q.acceptedanswerid = a.id
where a.owneruserid = ##id##
and a.communityowneddate is null
and q.owneruserid <> a.owneruserid
group by a.owneruserid

fork query

edited dec 5

created dec 5 anonymous