0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT 

(
SELECT COUNT(*)
FROM Votes
WHERE VoteTypeId IN(2,3)
-- GROUP BY PostId
)

/

(
SELECT COUNT(*) FROM Posts WHERE PostTypeId IN(1,2,3)
) 

AS media

fork query

edited aug 14 14

created aug 14 14 bfavaretto