Q&A for people looking to improve their interpersonal communication skills
select dateadd(week, datediff(week, 0, p.CreationDate), 0) wk, TagName, count(*) Questions from Posts p join PostTags pt on pt.PostId=p.Id join Tags t on t.Id=pt.TagId where p.CreationDate > '2020-01-01' and ( p.Tags like '%<postgresql%' or p.Tags like '%<psql>%' or p.Tags like '%<postgis>%' or p.Tags like '%<plpgsql>%' ) group by dateadd(week, datediff(week, 0, p.CreationDate), 0), TagName order by dateadd(week, datediff(week, 0, p.CreationDate), 0)