Q&A for scientists using computers to solve scientific problems
SELECT YEAR(CreationDate) AS year1, MONTH(CreationDate) AS month1, Location, COUNT(Id) AS user_count FROM Users WHERE YEAR(CreationDate) = 2023 GROUP BY YEAR(CreationDate), MONTH(CreationDate), Location ORDER BY YEAR(CreationDate) DESC, MONTH(CreationDate), Location DESC