Q&A for enthusiasts and power users of the Android operating system
DECLARE @GoldWeight INT = 3 DECLARE @SilverWeight INT = 2 DECLARE @BronzeWeight INT = 1 SELECT TOP 1000 * FROM Users u INNER JOIN Badges b ON u.Id = b.UserId WHERE u.Id = 8574934 --ORDER BY (Reputation/XXX)