SELECT Posts.OwnerUserId as [User Link], TagName, sum(Sco...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Islam Meta

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

SELECT
    Posts.OwnerUserId as [User Link],
    TagName,
    sum(Score) AS Score 
FROM Tags
    INNER JOIN PostTags ON PostTags.TagId = Tags.id
    INNER JOIN Posts ON Posts.ParentId = PostTags.PostId
WHERE CommunityOwnedDate is null 
GROUP BY TagName, Posts.OwnerUserId 
HAVING sum(Score) > 99 and sum(Score) < 162 -- sum(Score) < 261
ORDER BY sum(Score) DESC

Enter Parameters

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