0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

SELECT TOP 100
  U1.DisplayName AS SFFUserName,
  U1.Id AS SFFUserId,
  U1.Reputation AS SFFReputation,
  U2.DisplayName AS ArqadeUserName,
  U2.Id AS ArqadeUserId,
  U2.Reputation AS ArqadeReputation
FROM [StackExchange.scifi].dbo.Users U1, [StackExchange.gaming].dbo.Users U2
WHERE
  U1.AccountId = U2.AccountId
ORDER BY
  CASE
    WHEN U1.Reputation > U2.Reputation THEN U2.Reputation
    ELSE U1.Reputation
  END DESC, U1.AccountId;

fork query

edited nov 28 23 anonymous

created oct 13 19 peterh (2)