1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

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;

fork query

edited nov 9 19

created nov 9 19 peterh - PLEASE DELETE THIS ACCOUNT