Answer Stats for Thomas

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT
COUNT(*)
FROM  
            Posts     PPP
INNER JOIN  PostTypes PTT ON PPP.PostTypeId = PTT.Id
WHERE 
    PPP.OwnerUserId = 1005481 
AND PTT.Name = 'Answer'

SELECT
COUNT(*)   
FROM  
            Posts     PPP
INNER JOIN  PostTypes PTT ON PPP.PostTypeId = PTT.Id
INNER JOIN  Posts     QQQ ON PPP.ParentId   = QQQ.Id
WHERE 
    PPP.OwnerUserId      = 1005481 
AND PTT.Name             = 'Answer'
AND QQQ.AcceptedAnswerId IS NOT NULL

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached