0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

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, VoteCount
FROM RankedUpVotes
UNION ALL
SELECT PostId, VoteCount
FROM RankedDownVotes;

fork query

edited nov 4 jon.doe46194

created nov 4 anonymous