Tags that I am in the Top 5 answeres

10

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackoverflow.com/questions/350902/tags-that-i-am-in-the-top-5-answeres

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

select a.owneruserid
     , t.tagname 
     , sum(a.score) [tag score]
     , rank() over(partition by t.tagname, sum(a.score) order by sum(a.score) desc )
from posts a
inner join posts q on q.id = a.parentid
inner join posttags pt on pt.postid = q.id
inner join tags t on t.id = pt.tagid
where a.posttypeid = 2 -- answer
and q.posttypeid = 1 -- Question
group by a.owneruserid
       , t.tagname
having sum(a.score) > 10

Enter Parameters

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