Q&A for developers and researchers interested in open data
With prelim As ( Select u.Id As Username, floor(10+0.5*u.Reputation/1000-0.5*abs(u.Reputation/1000-20)) As CappedRep, Count(distinct b.Name) As BadgeCount, u.LastAccessDate As LastAccess From Users u Inner Join Badges b On b.UserId = u.Id Where u.Reputation >= 1000 and b.Name in ( 'Civic Duty', 'Cleanup', 'Constituent', 'Convention', 'Copy Editor', 'Deputy', 'Electorate', 'Enthusiast', 'Explainer', 'Investor', 'Marshal', 'Organizer', 'Quorum', 'Refiner', 'Sportsmanship', 'Strunk & White', 'Tag Editor', 'Reviewer', 'Steward', 'Yearling') Group By u.Id, u.Reputation, u.LastAccessDate ) Select Username as [User Link], CappedRep+BadgeCount as Total, CappedRep, BadgeCount, LastAccess From prelim Order By Total desc