1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

DECLARE @MinNumberOfQuestions int = ##MinNumberOfQuestions##

select Min(p.CreationDate) CreationDate, t.TagName TagName, Count(t.TagName) Count
from Posts p
inner join PostTags pt on p.Id = pt.PostId
inner join Tags t on t.Id = pt.TagId
where PostTypeId = 1
group by t.TagName
having Count(t.TagName) >= @MinNumberOfQuestions
order by Min(p.CreationDate)

fork query

edited nov 8 19

created nov 10 18 Renato Dinhani