Frequency of question score by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

-- Frequency of question score by tag

select t.TagName, p.Score, count(1)
from PostTags pt
inner join Posts p on p.Id = pt.PostId
inner join Tags t on t.Id = pt.TagId
where pt.TagId in (
  select top 10 TagId
  from PostTags
  group by TagId
  order by count(1) desc)
group by t.TagName, p.Score
order by t.TagName, p.Score

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached