SELECT pp.MentionsInjection , SUM(case when


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

        SELECT  pp.MentionsInjection
        ,       SUM(case when v.votetypeid = 2 then 10
                         when v.votetypeid = 3 then -2
                         else null 
                    end) / COUNT(distinct AS RepGain
        FROM    tags t
        JOIN    posttags pt
        ON      pt.tagid =
        JOIN    (
                select  *
                ,       case when body like '%xkcd%' then 1 
                             else 0 
                        end as MentionsInjection
                from    posts
                ) pp
        ON = pt.postid
        JOIN    posts pa
        ON      pa.parentid =
        JOIN    votes v
        ON      v.postid =
        WHERE   t.tagname = 'sql'
        GROUP BY 

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results