By Each Tag Post Creation Date Total Posts Average Views Score Answer Count


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 50000 'gas' as [Tag Name], convert(date, p.CreationDate) as [DateCreated], count( as [Number of Posts], avg(ViewCount) as [Average Views], avg(Score) as [Average Score], avg(AnswerCount) as [Average Answers]
from Tags t, PostTags pt, Posts p
where t.Id = pt.TagId and p.Id = pt.PostId and p.PostTypeId = 1 and p.ClosedDate is null and AnswerCount > -1 and t.TagName = 'progressive-web-apps'
group by convert(date, p.CreationDate)
order by convert(date, p.CreationDate)

Enter Parameters

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