0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast 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

fork query

edited jun 20 14

created jun 20 14 ForkandBeard