Q&A about the site for professional robotic engineers, hobbyists, researchers and students
SELECT TOP 100 U1.DisplayName AS MathUserName, U1.Id AS MathUserId, U1.Reputation AS MathReputation, U2.DisplayName AS PhysicsUserName, U2.Id AS PhysicsUserId, U2.Reputation AS PhysicsReputation FROM [StackExchange.Math].dbo.Users U1, [StackExchange.Physics].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;