with wks as ( select datepart(week, creationdate) as wk, ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Super User

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

Enter Parameters

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