0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

-- Daily Review Statistics on Stack Overflow (January 2020 to January 2024)
-- This query returns the daily count of reviews completed.

SELECT
    DATEPART(year, rtr.CreationDate) AS Year,
    DATEPART(month, rtr.CreationDate) AS Month,
    DATEPART(day, rtr.CreationDate) AS Day,
    COUNT(DISTINCT rtr.Id) AS ReviewsCompleted
FROM
    ReviewTaskResults rtr
WHERE
    rtr.CreationDate BETWEEN '2020-01-01' AND '2024-01-01'
GROUP BY
    DATEPART(year, rtr.CreationDate),
    DATEPART(month, rtr.CreationDate),
    DATEPART(day, rtr.CreationDate)
ORDER BY
    Year,
    Month,
    Day;

fork query

edited apr 15

created apr 15 Jaeung Sim