instruction: Questions by week by tag.
response: SELECT DATEADD(DAY, 0, DATEADD(DAY, -DATEPART(DW, CAST('1/1/' + CAST(Year AS VARCHAR) AS DATE)) + 2, DATEADD(WK, Week - 1, CAST('1/1/' + CAST(Year AS VARCHAR) AS DATE)))) AS Date, Questions FROM (SELECT DATEPART(YYYY, Posts.CreationDate) AS Year, DATEPART(WW, Posts.CreationDate) AS Week, COUNT(*) AS Questions FROM Posts WHERE PostTypeId = 1 AND Id IN (SELECT PostId FROM PostTags WHERE TagId IN (SELECT Id FROM Tags WHERE TagName = 'typescript')) GROUP BY DATEPART(YYYY, Posts.CreationDate), DATEPART(WW, Posts.CreationDate)) AS x ORDER BY 1