Find the highest-rep users whose combined reputation is more than X% of the total user reputation. Let's make Pareto proud.
Q&A about the site for software quality control experts, automation engineers, and software testers
-- Elite Users: Those who hold > X% of all Reputation -- Find the highest-rep users whose combined reputation -- is more than X% of the total user reputation. -- Let's make Pareto proud. DECLARE @MyAnswerUpped int = 0; -- +10 SELECT @MyAnswerUpped = COUNT(*) FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.Id INNER JOIN Posts AS A ON A.ParentId = PostTags.PostId and A.PostTypeId = 2 INNER JOIN Votes AS U ON U.PostId = A.Id and U.VoteTypeId = 2 INNER JOIN ( select Id from Users where Reputation > 100000 and Reputation < 110000 )as t1 ON t1.Id = A.OwnerUserId