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 
    YEAR(CreationDate) AS Year,
    MONTH(CreationDate) AS Month,
    COUNT(*) AS NewUsers
FROM 
    Users
WHERE 
    YEAR(CreationDate) BETWEEN 2020 AND 2024
GROUP BY 
    YEAR(CreationDate), 
    MONTH(CreationDate)
ORDER BY 
    Year, 
    Month;

fork query

created nov 12 anonymous