Q&A for professional and enthusiast programmers
-- Up vs Down votes by hour of day of Accepted Answer SELECT DATEPART(HOUR, p.CreationDate) AS Hour, 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 AcceptedAnswerId IS NOT NULL GROUP BY DATEPART(HOUR, p.CreationDate) ORDER BY DATEPART(HOUR, p.CreationDate)