0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, researchers and practitioners of computer science

WITH RankedUpVotes AS (
    SELECT TOP 10 COUNT(v.Id) VoteCount, v.PostId
    FROM Votes v
    WHERE v.VoteTypeId = 2
    GROUP BY v.PostId
    ORDER BY count(v.Id) DESC

),
RankedDownVotes as (
    SELECT TOP 10 COUNT(v.Id) VoteCount, v.PostId
    FROM Votes v
    WHERE v.VoteTypeId = 3
    GROUP BY v.PostId
    ORDER BY count(v.Id) DESC

)
SELECT PostId
FROM RankedUpVotes
UNION ALL
SELECT PostId
FROM RankedDownVotes;

view current version

edited nov 8

created nov 8 Janis123