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,
      month1, year1
      FROM(

SELECT 
        Id,
        CAST(DATEPART(month, CreationDate) AS numeric) AS month1,
        CAST(DATEPART(year, CreationDate) AS numeric) AS year1
    FROM 
        Users
     GROUP BY Id, CreationDate
        ) AS A 
        GROUP BY Id, month1, year1
        ORDER BY month1, year1

fork query

edited nov 15

created nov 14 anonymous