SELECT COUNT_BIG(*) FROM dbo.Posts AS P JOIN dbo.PostType...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT COUNT_BIG(*)
FROM dbo.Posts AS P
JOIN dbo.PostTypes AS PT
    ON PT.Id = P.PostTypeId
WHERE
    PT.Name = N'Question'
    AND P.AcceptedAnswerId IS NOT NULL;

Enter Parameters

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