0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

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 22

created dec 5 22 anonymous