0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

DECLARE @AID int = ##AnswerID##

SELECT
    DATEFROMPARTS(YEAR(v.CreationDate), MONTH(v.CreationDate), 1) AS [Year-Month],
    COUNT(CASE WHEN v.VoteTypeId = 2 THEN 1 ELSE NULL END) AS [Upvotes],
    COUNT(CASE WHEN v.VoteTypeId = 3 THEN 1 ELSE NULL END) AS [Downvotes]

FROM Posts answers
    INNER JOIN 
        Posts p ON answers.parentid = p.id
    INNER JOIN
        Votes v ON v.postid = p.id

WHERE v.VoteTypeId IN (2,3) -- Limit to Up/ Downvotes
    AND answers.id = @AID
    AND (v.CreationDate >= '##Date1?2017-04-01##') AND (v.CreationDate <= '##Date2?2022-04-30##')

GROUP BY DATEFROMPARTS(YEAR(v.CreationDate), MONTH(v.CreationDate), 1), v.postid, p.id

ORDER BY DATEFROMPARTS(YEAR(v.CreationDate), MONTH(v.CreationDate), 1) ASC

view current version

edited may 9 22

created may 9 22 Rukaku