Country Ranking

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

SELECT
  RANK() OVER (ORDER BY Speed DESC) AS [Ranking],
  *
FROM (
   SELECT TOP(2000)
    Reputation/CAST(CASE MemberTime WHEN 0 THEN NULL ELSE MemberTime END AS REAL) AS Speed,
    *
  FROM (
    SELECT
      CAST(GETDATE()-CreationDate AS REAL) AS MemberTime,
      *
    FROM
      Users
    ) AS sq1
  ORDER BY Speed DESC
  ) AS sq2
ORDER BY Ranking

Enter Parameters

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