Q&A for computer enthusiasts and power users
with wks as ( select datepart(week, creationdate) as wk, posts.Id from posts join posttags on posts.id = posttags.postid join tags on posttags.tagid = tags.id where tags.tagname = 'kubernetes' and posts.creationdate > '2019-03-09' ) select wk, count(id) from wks group by wk