User Posts Per Week

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
concat(cast(datepart(week, CreationDate) as varchar(2)), year(creationdate)),
COUNT(id)
FROM posts
WHERE OwnerUserId = 139010
GROUP BY datepart(week, CreationDate), year(creationdate)
order by year(creationdate) desc, datepart(week, CreationDate) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results