Q&A for professional and enthusiast programmers
select top 50000 'gas' as [Tag Name], convert(date, p.CreationDate) as [DateCreated], count(p.id) 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)