0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

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