select u.DisplayName as Пользователь, count(p.Id) as [Чис...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select u.DisplayName as Пользователь, count(p.Id) as [Число вопросов]
from Posts p left join Users u on p.OwnerUserId = u.Id
where Tags like N'%<%-faq>%'
group by p.OwnerUserId, u.DisplayName
order by count(p.Id) desc

Enter Parameters

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