instruction: What is my reputation's percentile?. Computes what percentage of users have lower reputation than the given user ID.
  A minimum reputation can be specified to cut off one-time users and other such outliers. (use a large negative number to consider all users)
response: WITH Population(TotalUsers, UsersBelowMe) AS (SELECT SUM(CASE WHEN uAll.Reputation > '##MinReputation##' THEN 1 ELSE 0 END) AS TotalUsers, SUM(CASE WHEN uAll.Reputation < uMe.Reputation AND uAll.Reputation > '##MinReputation##' THEN 1 ELSE 0 END) AS UsersBelowMe FROM Users AS uMe CROSS JOIN Users AS uAll WHERE uMe.Id = '##UserId##') SELECT 100.0 * UsersBelowMe / TotalUsers AS Percentile, UsersBelowMe, TotalUsers FROM Population