Q&A for professional and enthusiast programmers
SELECT CAST(CreationDate AS DATE) as date, COUNT(*) as c FROM Users GROUP BY CAST(CreationDate AS DATE) ORDER BY date