Top Tag Answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

History

Q&A for historians and history buffs

SELECT
    COUNT(Id) AS User_Number,
    CONVERT(char(7),CreationDate,120) AS TimeRange,
    SUM(case when Reputation > 1000 Then 1 else 0 end) AS Rep1000,
    SUM(case when Reputation > 2000 Then 1 else 0 end) AS Rep2000,
    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 convert(char(7),CreationDate,120)

Enter Parameters

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