Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT COUNT(Id) as UserCount, CAST(DATEPART(month, CreationDate) AS numeric) AS month1, CAST(DATEPART(year, CreationDate) AS numeric) AS year1--, --Location FROM Users --WHERE Location IS NOT NULL GROUP BY Id, CAST(DATEPART(month, CreationDate) AS numeric), CAST(DATEPART(year, CreationDate) AS numeric)--, Location