Percentage of the total rep of users with "monica" substring

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

WITH Monica AS (
  SELECT SUM(Reputation) AS Monica
  FROM Users
  WHERE LOWER(DisplayName) LIKE '%monica%'
),
SumRep AS (
  SELECT SUM(Reputation) AS SumRep
  FROM Users
)
SELECT Monica.Monica, SumRep.SumRep, 100.0 * Monica.Monica / SumRep.SumRep AS Pct
FROM Monica, SumRep;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results