Annual count of closed but not deleted questions using business-related tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Theoretical Computer Science

Q&A for theoretical computer scientists and researchers in related fields

-- Annual count of closed but not deleted questions using business-related tags

select year(CreationDate) as Year, count(Tags) from Posts
  where (
    Tags like '%<accounting>%'
    or Tags like '%<bookkeeping>%'
    or Tags like '%<business>%'
    or Tags like '%<double-entry>%'
    or Tags like '%<small-business>%'
    or Tags like '%<start-up>%'
  )
  and PostTypeId = 1
  and ClosedDate is not null
  group by year(CreationDate)
  order by Year asc

Enter Parameters

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