0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited nov 15

created nov 14 anonymous