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

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