Average reputation of users depending on age

1

Please login or register to vote for this query.

(click on this box to dismiss)

Blender Meta

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

SELECT
  DATEDIFF(month, u.CreationDate, CAST(GETDATE() AS Date)) AS Months,
  AVG(CAST(u.Reputation AS decimal))
FROM Users u  
GROUP BY DATEDIFF(month, u.CreationDate, CAST(GETDATE() AS Date)) 
ORDER BY DATEDIFF(month, u.CreationDate, CAST(GETDATE() AS Date)) 
---month between CreationDate and today

Enter Parameters

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