0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers and researchers interested in open data

SELECT 
  u.ID,
  CONVERT(DATE, u.CreationDate) AS UserCreateDate,
  MIN(CONVERT(DATE, p.CreationDate)) AS FirstPostJan,
  MAX(CONVERT(DATE, p.CreationDate)) AS LastPostJan,
  COUNT(*) AS PostCount
FROM Users u
INNER JOIN Posts p ON u.ID = p.OwnerUserId
WHERE 
  CONVERT(DATE, u.CreationDate) = '2021-12-23'  -- Hardcoded date
  AND YEAR(p.CreationDate) = 2022  -- January 2022
  AND MONTH(p.CreationDate) = 1  -- January
GROUP BY u.ID, CONVERT(DATE, u.CreationDate)
ORDER BY PostCount DESC;

fork query

edited dec 7

created dec 7 anonymous