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

SELECT
    YEAR(p.CreationDate) AS Year,
    COUNT(DISTINCT p.OwnerUserId) AS ActiveUsers
FROM
    Posts p
WHERE
    p.OwnerUserId IS NOT NULL
    AND YEAR(p.CreationDate) >= 2016
    AND YEAR(p.CreationDate) <= 2023
GROUP BY
    YEAR(p.CreationDate)
ORDER BY
    Year;

fork query

edited jan 29

created jan 29 anonymous