1

Please login or register to vote for this query.

(click on this box to dismiss)

Calculates the percentage of questions tagged with nodatime that are answered by the legend hinself, Jon Skeet

Q&A for professional and enthusiast programmers

SELECT 100*COUNT(a.Id)/COUNT(q.Id) AS Percentage FROM
    Posts q
    LEFT JOIN Posts a
        ON q.Id=a.ParentId
            AND a.OwnerUserId='22656'
            -- AND q.AcceptedAnswerId=a.Id -- if you only want accepted answers
    INNER JOIN PostTags pt
        ON q.Id=pt.PostId
    INNER JOIN Tags t
        ON pt.TagId=t.Id
WHERE q.ParentId IS NULL
    AND t.TagName='nodatime'

fork query

edited mar 28 21

created mar 28 21 dan1st