0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Ubuntu users and developers

SELECT 
    FORMAT(YEAR(CreationDate), '0000') + '-' + 
    FORMAT(MONTH(CreationDate), '00') + '-01 00:00:00' AS MonthStart,
    COUNT(*) AS NewUsers
FROM 
    Users
WHERE 
    YEAR(CreationDate) BETWEEN 2020 AND 2024
GROUP BY 
    YEAR(CreationDate), 
    MONTH(CreationDate)
ORDER BY 
    MonthStart;

fork query

edited nov 12

created nov 12 anonymous