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)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

-- 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 main site
loading Hold tight while we fetch your results