1

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT
TOP 1000 *
FROM (
    SELECT
        u1.displayname
        , u1.Reputation AS u1_Reputation
        , u2.Reputation AS u2_Reputation
        , u3.Reputation AS u3_Reputation
        , u1.Reputation + u2.Reputation + u3.Reputation AS Reputation_sum
    FROM [StackOverflow]..[Users] u1
        INNER JOIN [ServerFault]..[Users] u2 ON u1.AccountId = u2.AccountId
        INNER JOIN [SuperUser]..[Users] u3 ON u2.AccountId = u3.AccountId
)  
a
ORDER BY reputation_sum DESC

fork query

edited aug 27 19

created aug 27 19 jon.doe32050