0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

-- Money: Annual count of closed or deleted questions that used accounting/business-related tags

select year(CreationDate) as Year, count(Tags) from PostsWithDeleted
  where (
       Tags like '%<accounting>%'
    or Tags like '%<balance-sheet>%'
    or Tags like '%<book-value>%'
    or Tags like '%<bookkeeping>%'
    or Tags like '%<business>%'
    or Tags like '%<corporation>%'
    or Tags like '%<double-entry>%'
    or Tags like '%<income-statement>%'
    or Tags like '%<incorporating>%'
    or Tags like '%<limited-liability-company>%'
    or Tags like '%<llc>%'
    or Tags like '%<non-profit>%'
    or Tags like '%<partnership>%'
    or Tags like '%<private-company>%'
    or Tags like '%<quickbooks>%'
    or Tags like '%<quickbooks-online>%'
    or Tags like '%<s-corporation>%'
    or Tags like '%<sba>%'
    or Tags like '%<self-employment>%'
    or Tags like '%<small-business>%'
    or Tags like '%<sole-proprietorship>%'
    or Tags like '%<start-up>%'
    or Tags like '%<vat>%'
  )
  and PostTypeId = 1
  and (ClosedDate is not null or DeletionDate is not null)
  group by year(CreationDate)
  order by Year asc

view current version

edited nov 25

created nov 25 Chris W. Rea