instruction: Users (with minimum rep) ranked by Median Post Score. Under construction
response: SELECT OwnerUserId AS "user_link", AVG(Score) AS MedianScore FROM (SELECT OwnerUserId, Score, ROW_NUMBER() OVER (PARTITION BY OwnerUserId ORDER BY Score) AS RowAsc, ROW_NUMBER() OVER (PARTITION BY OwnerUserId ORDER BY Score DESC) AS RowDesc FROM Posts INNER JOIN Users ON Users.Id = OwnerUserId WHERE Users.Reputation >= '##MinReputation##' AND Posts.PostTypeId = 2) AS x WHERE RowAsc IN (RowDesc, RowDesc - 1, RowDesc + 1) GROUP BY OwnerUserId ORDER BY MedianScore DESC