/*SELECT TOP 10 T.TagName, SUM(P.AnswerCount) FROM Posts ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Psychology and Neuroscience Meta

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

/*SELECT TOP 10 T.TagName, SUM(P.AnswerCount)
FROM Posts P 
JOIN PostTags PT ON P.Id = PT.PostId
JOIN Tags T ON PT.TagId = T.Id
WHERE P.PostTypeId = 2
GROUP BY T.TagName*/

SELECT COUNT(1) CntAcceptesAnswer
FROM Posts Q 
JOIN
  (
    SELECT Id, ParentId
    FROM Posts 
    WHERE OwnerUserId = 6426692 AND PostTypeId = 2
  ) A ON Q.Id = A.ParentId AND Q.AcceptedAnswerId = A.Id
WHERE Q.Tags LIKE '%sql-server%'

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results