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)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

select top 50000 'javascript' 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 > 0 and t.TagName = 'javascript'
group by convert(date, p.CreationDate)
order by convert(date, p.CreationDate)

Enter Parameters

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