Q&A for people looking to improve their interpersonal communication skills
select dateadd(week, datediff(week, '2020-01-05', p.CreationDate), '2020-01-05') 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.CreationDate < dateadd(week, datediff(week, '2020-01-05', getdate()), '2020-01-05') and ( p.Tags like '%<postgresql%' or p.Tags like '%<psql>%' or p.Tags like '%<postgis>%' or p.Tags like '%<plpgsql>%' or p.Tags like '%<enterprisedb>%' ) and TagName not like 'postgresql%' and TagName not in ('psql', 'postgis', 'plpgsql', 'enterprisedb', 'sql', 'database') group by dateadd(week, datediff(week,'2020-01-05', p.CreationDate), '2020-01-05'), TagName order by dateadd(week, datediff(week, '2020-01-05', p.CreationDate), '2020-01-05'), count(*) desc