0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Ubuntu users and developers

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'
    AND p.CreationDate BETWEEN '2022-01-01' AND '2022-01-31' -- January 2022
GROUP BY u.ID, CONVERT(DATE, u.CreationDate)
ORDER BY PostCount DESC;

fork query

created dec 7 anonymous