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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sustainable Living

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results