Are self-answers voted on less?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

select iif(a.OwnerUserId = q.OwnerUserId, 'yes', 'no') "Self-answer?",
       avg(1.*isnull(a.Score, 0)) "Avg. Answer Score", 
       avg(1.*isnull(q.Score, 0)) "Avg. Question Score",
       count(distinct a.Id) N
from PostsWithDeleted a
     join PostsWithDeleted q on q.Id = a.ParentId
where a.PostTypeId = 2
group by iif(a.OwnerUserId = q.OwnerUserId, 'yes', 'no')

Enter Parameters

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