Most generalist users of the site

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

WITH ETags AS (
  SELECT TOP 40 Id AS TagId
  FROM Tags
  WHERE Count >= 200
  ORDER BY Count DESC, Id
),
Raw AS (
  SELECT
    A.OwnerUserId AS UserId,
    ETags.TagId,
    SUM(A.Score) AS Score
  FROM Posts Q, Posts A, PostTags, ETags
  WHERE
    A.ParentId = Q.Id
    AND
    A.CommunityOwnedDate IS NULL
    AND
    Q.Id = PostTags.PostId
    AND
    PostTags.TagId = ETags.TagId
    AND
    A.OwnerUserId > 0
  GROUP BY A.OwnerUserId, ETags.TagId
  HAVING SUM(A.Score) > 0
),
Raw2 AS (
  SELECT
    UserId,
    TagId,
    Score,
    100.0 * CASE WHEN Score >= 15 THEN 15 ELSE Score END / 15 AS Pct
  FROM Raw
),
Generality AS (
  SELECT UserId, SUM(Pct) AS Generality
  FROM Raw2
  GROUP BY UserId
)
SELECT
  DENSE_RANK() OVER (ORDER BY Generality DESC) AS Rank,
  UserId AS [User Link],
  FLOOR(Generality) AS Generality,
  CASE WHEN Generality >= 2000 THEN 'ELIGIBLE' END IsEligible
FROM Generality
ORDER BY Generality DESC, UserId

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results