Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games
-- Enter Query Title -- Enter Query Description DECLARE @badgeweight TABLE ( name varchar(100) collate SQL_Latin1_General_CP1_CS_AS, weight float) INSERT @badgeweight SELECT name, ((SELECT TOP 1 count(Name) FROM Badges WHERE NOT EXISTS (SELECT * FROM tags WHERE tags.tagname=badges.name) GROUP BY name ORDER BY count(Name) DESC)+0.0) / count(Name) as weight FROM Badges WHERE NOT EXISTS (SELECT * FROM tags WHERE tags.tagname=badges.name) GROUP BY name SELECT TOP 100 w.*, Badges.UserId FROM @badgeweight AS w JOIN Badges ON w.name = Badges.name -- SELECT TOP 20 UserId AS [User Link], count(*) as Badges -- FROM Badges -- GROUP BY UserId -- ORDER BY Badges DESC