0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

SELECT
    DATEPART(year, CreationDate) AS TimeRange,
    COUNT(Id) AS User_Number,
    SUM(case when Reputation > 1000 Then 1 else 0 end) AS Rep1000,
    SUM(case when Reputation > 1500 Then 1 else 0 end) AS Rep1500,
    SUM(case when Reputation > 2000 Then 1 else 0 end) AS Rep2000,
    SUM(case when Reputation > 2500 Then 1 else 0 end) AS Rep2500,
    SUM(case when Reputation > 3000 Then 1 else 0 end) AS Rep3000
FROM
    Users
WHERE
  Reputation > 1 AND
  CreationDate BETWEEN '2011-01-01 00:00:00'
    AND '2018-12-31 23:59:59'
    GROUP BY DATEPART(year, CreationDate)

fork query

edited jan 22 20

created jan 22 20 anonymous