0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

-- 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

fork query

edited nov 25

created nov 25 Chris W. Rea