Q&A for Graphic Design professionals, students, and enthusiasts
-- Yearly count of closed but not deleted questions that used a tag containing 'business'
select year([CreationDate]) as [Year], count(Tags) as [Count] from [Posts]
where [Tags] like '%business%'
and [PostTypeId] = 1
and [ClosedDate] is not null
group by year([CreationDate])
order by [Year] asc