Count combinations of mandatory tags on meta

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Overflow

Q&A about the site for professional and enthusiast programmers

select
  Count(*) as [Count],
  case when Tags like '%<discussion>%' or Tags like '%<support>%' then 'Yes' else 'No' end as [Question],
  case when Tags like '%<bug>%' or Tags like '%<feature-request>%' then 'Yes' else 'No' end as [Not-A-Question]
from Posts
where PostTypeId = 1
  and ClosedDate is null
  and CreationDate >= ##StartDate:string?2017-09-01##
  and CreationDate < ##EndDate:string?2017-10-01##
group by
  case when Tags like '%<discussion>%' or Tags like '%<support>%' then 'Yes' else 'No' end,
  case when Tags like '%<bug>%' or Tags like '%<feature-request>%' then 'Yes' else 'No' end

Enter Parameters

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