Got the most badges on the same day

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Apps

Q&A for apps, scripts, and development with the Stack Exchange API

WITH Raw AS (
  SELECT
    UserId,
    DATEFROMPARTS(
      DATEPART(yyyy, Date),
      DATEPART(mm, Date),
      DATEPART(d, DATE)) AS Date
  FROM Badges
)
SELECT TOP 100
  UserId,
  UserId AS [User Link],
  Date,
  COUNT(*) AS N
FROM Raw
GROUP BY UserId, Date
ORDER BY N DESC, UserId

Enter Parameters

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