- Stack Exchange Data Explorer

SELECT DATENAME(WEEKDAY, CreationDate) AS Day, Count(*) A...

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for programmers

SELECT
    DATENAME(WEEKDAY, 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
GROUP BY
    DATENAME(WEEKDAY, CreationDate)

created may 25 10