0

Please login or register to vote for this query.

(click on this box to dismiss)

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

-- 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 '%assets%'
    or Tags like '%balance-sheet%'
    or Tags like '%book-value%'
    or Tags like '%bookkeeping%'
    or Tags like '%business%'
    or Tags like '%cash-flow%'
    or Tags like '%consulting%'
    or Tags like '%contractor%'
    or Tags like '%contracts%'
    or Tags like '%corporation%'
    or Tags like '%crowdfunding%'
    or Tags like '%double-entry%'
    or Tags like '%financial-statements%'
    or Tags like '%general-partnership%'
    or Tags like '%gst%'
    or Tags like '%hobby-income%'
    or Tags like '%hst%'
    or Tags like '%income-statement%'
    or Tags like '%incorporating%'
    or Tags like '%liabilities%'
    or Tags like '%liability%'
    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 '%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

fork query

edited nov 25

created nov 25 Chris W. Rea