0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT
            AVG (p.Score)           AS [Avg Score],
            AVG (p.ViewCount)       AS [Avg ViewCount],
            AVG (p.FavoriteCount)   AS [Avg FavoriteCount],
            ROUND (AVG ( p.FavoriteCount * 100.0 / p.ViewCount )
                , 2
            ) AS [Avg Favorites per view (%)]
FROM        Posts           p
WHERE       p.PostTypeId    = 1 -- Question
AND         p.Score         > 10
AND         p.ViewCount     > 200

fork query

edited feb 29 12

created feb 29 12 Awesome Poodles