0

Please login or register to vote for this query.

(click on this box to dismiss)

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

-- Money: Annual count of closed or deleted questions that used either
--   specific accounting or business-related tags, but not tags that probably
--   relate back to any of personal finance, investing, employment, economics,
--   financial literacy, etc.

select year(CreationDate) as Year, count(Tags) from PostsWithDeleted
where ( Tags like '%<accounting>%'
    or Tags like '%<bookkeeping>%'
    or Tags like '%<business>%'
    or Tags like '%<consulting>%'
    or Tags like '%<contractor>%'
    or Tags like '%<corporation>%'
    or Tags like '%<crowdfunding>%'
    or Tags like '%<double-entry>%'
    or Tags like '%<general-partnership>%'
    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 '%<s-corporation>%'
    or Tags like '%<self-employment>%'
    or Tags like '%<small-business>%'
    or Tags like '%<sole-proprietorship>%'
    or Tags like '%<start-up>%' )
  and Tags not like '%401k%'
  and Tags not like '%education%'
  and Tags not like '%home%'
  and Tags not like '%invest%'
  and Tags not like '%option%'
  and Tags not like '%retire%'
  and Tags not like '%share%'
  and Tags not like '%stock%'
  and Tags not like '%student%'
  and Tags not like '%trading%'
  and Tags not like '%<annual-report>%'
  and Tags not like '%<asset-allocation>%'
  and Tags not like '%<commodities>%'
  and Tags not like '%<corporate-acquisition>%'
  and Tags not like '%<customer-service>%'
  and Tags not like '%<derivatives>%'
  and Tags not like '%<economics>%'
  and Tags not like '%<employment>%'
  and Tags not like '%<federal-reserve>%'
  and Tags not like '%<financial-advisor>%'
  and Tags not like '%<financial-literacy>%'
  and Tags not like '%<homework>%'
  and Tags not like '%<ipo>%'
  and Tags not like '%<ira>%'
  and Tags not like '%<market-data>%'
  and Tags not like '%<monetary-policy>%'
  and Tags not like '%<money-market>%'
  and Tags not like '%<mortgage>%'
  and Tags not like '%<mutual-funds>%'
  and Tags not like '%<passive-income>%'
  and Tags not like '%<portfolio>%'
  and Tags not like '%<promotion>%'
  and Tags not like '%<rental-property>%'
  and Tags not like '%<reward-program>%'
  and Tags not like '%<resp>%'
  and Tags not like '%<rrsp>%'
  and Tags not like '%<scams>%'
  and Tags not like '%<school>%'
  and Tags not like '%<sec>%'
  and Tags not like '%<spin-off>%'
  and Tags not like '%<technical-analysis>%'
  and Tags not like '%<trusts>%'
  and Tags not like '%<university>%'
  and Tags not like '%<vesting>%'
  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