Q1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

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

SELECT
  Users.id, 
  MONTH(Posts.CreationDate) AS _month, 
  SUM(Posts.ViewCount) AS _viewscount, 
  ROW_NUMBER() over (ORDER BY SUM(Posts.ViewCount)) AS ranking
FROM Users 
JOIN Posts ON (Users.id = Posts.OwnerUserId)
GROUP BY Users.id, MONTH(Posts.CreationDate)
ORDER BY _viewscount DESC

Enter Parameters

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