Top C/C++ Developers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Tridion

Q&A for Tridion developers and administrators

select
ROW_NUMBER() OVER (ORDER BY tuser.Tag_Score desc) AS User_Rank_On_Tag,
(PERCENT_RANK( ) OVER(ORDER BY tuser.Tag_Score desc) * 100) AS [TOP_%],
us.ID [User_Link],
us.DisplayName,
us.Reputation,
us.Location,
tuser.Tag_Score
from Users us

JOIN
(SELECT Answers.OwnerUserID AS UserId, SUM(Answers.Score) AS Tag_Score
from Tags
JOIN PostTags ON Tags.Id = PostTags.TagId
JOIN Posts ON Posts.Id = PostTags.PostId
JOIN Posts Answers ON Answers.ParentId = Posts.Id
WHERE UPPER(Tags.TagName) = UPPER('c')
GROUP BY Answers.OwnerUserId
) tuser ON tuser.UserId = us.Id

WHERE UPPER(us.Location) like UPPER('Freiburg')
ORDER BY tuser.Tag_Score desc, us.Reputation desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results