Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT YEAR(CreationDate) AS year1, MONTH(CreationDate) AS month1, Location, COUNT(Id) AS user_count FROM Users GROUP BY YEAR(CreationDate), MONTH(CreationDate), Location ORDER BY YEAR(CreationDate) DESC, MONTH(CreationDate), Location DESC