0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for alcoholic beverage aficionados and those interested in beer, wine, or spirits

SELECT u.Id, u.Reputation, u.DisplayName, DATEPART(YEAR, p.CreationDate) as Year, DATEPART(MONTH, p.CreationDate) as Month, Count(*) as Count 
        FROM Users u
        inner join Posts p on u.Id = p.OwnerUserId
        where DATEPART(Year, p.CreationDate) =  2012 and 
        p.PostTypeId = 2
        and u.Reputation >= 20000
        GROUP BY u.Id, u.Reputation, u.DisplayName, DATEPART(YEAR, p.CreationDate), DATEPART(MONTH, p.CreationDate)
        ORDER BY -Reputation, u.Id, Year, Month ASC

view current version

edited nov 19 17

created nov 19 17 anonymous