Rank change for last twelve (12) months

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

SELECT v.PostId, v.VoteTypeId, t.Name, v.CreationDate,
CASE  
    WHEN v.VoteTypeId IN (1) THEN 15
    WHEN v.VoteTypeId IN (2) THEN 10
    WHEN v.VoteTypeId IN (3) THEN -2
    Else 0
END AS Answer1
FROM Votes v
JOIN VoteTypes t ON v.VoteTypeId = t.Id
WHERE PostId IN (
SELECT Id
FROM Posts
WHERE OwnerUserId = ##UserId##)
ORDER BY PostId

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results