Questions with [tag] closed as duplicate

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

declare @tag nvarchar(35) = ##tag:string##



select 
year(ClosedDate) as [Year],
count(*) as [Questions]
from 
posts
left join PostHistory as PH on PH.PostId = posts.Id
where 
charindex(@tag,Tags) > 0
and PostTypeId = 1
and ClosedDate is not null 
and Comment = '101'
group by
year(ClosedDate)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results