Unresolved questions with answers by user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Writers

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

-- Unresolved questions with answers by user

select
    count(P.Id) as "Questions",
    count(P2.Id) as "Unresolved",
    10000 * count(P2.Id) / count(P.Id) / 100.0 as "Percent",
    min(U.DisplayName) as "Who",
    min(U.Reputation) as "Rep",
    year(min(U.CreationDate)) as "Joined",
    year(min(U.LastAccessDate)) as "Last Seen"
from Posts P
    left join Users U on P.OwnerUserId = U.Id
    left join Posts P2 on P.Id = P2.Id and P2.AcceptedAnswerId is null
    where P.AnswerCount > 0 
    group by U.Id
    order by "Unresolved" desc, "Percent" desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results