0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

Select
u.ID AS USERID, 
CAST(u.creationdate AS DATE) AS UserCreateDate,
MIN(p.CreationDate) AS JanuaryFirstPostDate,
MAX(p.CreationDate) AS JanuaryLastPostDate,
COUNT(p.Id) AS JanuaryPostCount
FROM 
Users u 
JOIN
posts p ON u.Id = p.OwnerUserId
WHERE 
	CAST(u.CreationDate AS DATE) = '2021-12-23'
	AND p.CreationDate >= '2022-01-01'
	AND p.CreationDate < '2022-02-01'
GROUP BY
	u.Id, CAST(u.CreationDate AS DATE) 
ORDER BY
	JanuaryPostCount DESC;

fork query

edited dec 13

created dec 13 anonymous