Comments per week


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for those using, extending or developing Emacs

select year, week, count(*) as comments from
(select datepart(year, Comments.CreationDate) as year, 
datepart(week, Comments.CreationDate) as week, Comments.Id from Comments
join Users on Comments.UserId = Users.Id
where (upper(Users.Location) like upper('%New Zealand%')
or upper(Location) = upper('nz')
or upper(Location) like upper('NZ,%')
or upper(Location) like upper('%,NZ'))
and Comments.CreationDate >='2017-01-01') T0
group by year, week
Order by year, week;

Enter Parameters

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