How "Favorited" are questions of a certain minimum quality?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT TOP 200
            p.Id            AS [Post Link],
            p.Score,
            p.ViewCount,
            p.FavoriteCount,
            ROUND (
                p.FavoriteCount * 100.0 / p.ViewCount, 2
            ) AS [Favorites per view (%)]
FROM        Posts           p
WHERE       p.PostTypeId    = 1 -- Question
AND         p.Score         > 10
AND         p.ViewCount     > 200
ORDER BY    ROUND (p.FavoriteCount * 100.0 / p.ViewCount, 2)  DESC,
            p.ViewCount DESC

Enter Parameters

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