Пользователи по количеству популярных вопросов

0

Please login or register to vote for this query.

(click on this box to dismiss)

Literature Meta

Q&A about the site for scholars and enthusiasts of literature

select p.OwnerUserId as [User Link],
      count(1) as TotalCount,
      sum(case when p.ViewCount>=1000 then 1 else 0 end) as PopularCount,
      sum(case when p.ViewCount>=1000 then 1 else 0 end)*1.0/count(1) as PopularRatio
from Posts p
where p.PostTypeId = 1
group by p.OwnerUserId
having count(1) >= 10 and sum(case when p.ViewCount>=1000 then 1 else 0 end) > 0
order by PopularRatio desc

Enter Parameters

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