0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited mar 31

created mar 31 anonymous