SELECT ( SELECT COUNT(*) FROM Votes WHERE VoteTypeId IN(...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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

Enter Parameters

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