1

Please login or register to vote for this query.

(click on this box to dismiss)

Get the users score per question per tag.

Q&A for anime and manga fans

-- Per Tag User Awesomeness
-- Get the users score per question per tag.
select
    TagName,
    Score,
    Answers,
    Tags.Count,
    1.00 * Score / Tags.Count as Awesomeness
from
(
    select
        sum(Posts.Score) as Score,
        count(Posts.Id) as Answers,
        PostTags.TagId
    from Posts
    join PostTags on PostTags.PostId = Posts.ParentId
    where
        PostTypeId = 2
        and
        OwnerUserId = ##UserId:int##
        and
        Score > 0
    group by PostTags.TagId
) TagScores
left join Tags on TagId = Tags.Id
order by (1.00 * Score / Tags.Count) desc

fork query

created jul 10 11 Brian Reichle