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
--https://data.stackexchange.com/stackoverflow/query/145507/user-reputation-excluding-reputation-earned-on-a-certain-tag DECLARE @MyAnswerUpped int = 0; -- +10 -- SELECT --@MyAnswerUpped = COUNT(*) --select count(*) *10 as AnsRep, max(t1.Reputation) as TotRep ,t1.Id select avg(RepRatio) from ( select (sum(case when Q.AcceptedAnswerId is null then 0 else 1 end)*15+ count(*) *10.0 )/ max(t1.Reputation) as RepRatio ,t1.Id FROM Posts INNER JOIN Votes ON Posts.Id = Votes.PostId and Votes.VoteTypeId = 2 and Posts.PostTypeId = 2 INNER JOIN ( select Id, Reputation from Users where Reputation > 100000 and Reputation < 110000 )as t1 ON t1.Id = Posts.OwnerUserId left JOIN Posts AS Q ON Q.Id = Posts.ParentId and Q.AcceptedAnswerId = Posts.Id group by t1.Id )as tratio