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
convert(char(7),CreationDate,120), count(Id), sum(case when Reputation > 2000 Then 1 else 0 end)
FROM
  Users
WHERE
  reputation > 1
GROUP BY convert(char(7),CreationDate,120)

Enter Parameters

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