SELECT UserId, YEAR(creationdate) as year, MONTH(creation...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT 
    UserId,
    YEAR(creationdate) as year,
    MONTH(creationdate) as month,
    count(id) as [Comments Posted]
FROM comments
where UserId in ('16007','182668','134554','223992','9204','15416','3501','65863','139985','179910','252228','225074','7432','3043','143305','218196','22656','87189','69545','107090','50617','2988','65387','149392','33518','23354','6309','13508','1338','115145','18771','14860','476','131930','16406','15168','146325','89817','140750','13302','1968','19068')
group by userid, YEAR(creationdate), MONTH(creationdate)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results