1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Up vs Down votes by day of week of Accepted Answer

SELECT
    DATENAME(WEEKDAY, p.CreationDate) AS Day,
    Count(*) AS Amount,
    SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS UpVotes,
    SUM(CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END) AS DownVotes,
    (CAST(SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS float) / CAST(SUM(CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END) AS float)) AS UpVoteDownVoteRatio
FROM
    Votes v JOIN Posts p ON v.PostId=p.AcceptedAnswerId
WHERE
    PostTypeId=1 AND p.AcceptedAnswerId IS NOT NULL
 AND 
    VoteTypeId In (2,3)
GROUP BY
    DATEPART(WEEKDAY, p.CreationDate), DATENAME(WEEKDAY, p.CreationDate)
ORDER BY
    DATEPART(WEEKDAY, p.CreationDate)

fork query

edited may 10 12

created aug 4 10 Mark Hurd