Unresolved questions with answers by user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow en español

Preguntas y respuestas para programadores y profesionales de la informática

select top 100
    count(P.Id) as "Questions",
    count(P2.Id) as "Unresolved",
    format(100.0 * count(P2.Id) / count(P.Id), 'N') 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 and U.Id > -1
    group by U.Id
    order by "Unresolved" desc, "Percent" desc

Enter Parameters

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