0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

;WITH CTE
AS
(
	SELECT u.Id
	FROM Users as u
	WHERE u.Reputation > 50 AND
			u.CreationDate >= DATEADD(dd, -90, '2024-02-18 12:10:01')
)
SELECT TOP 1000 u.*
FROM CTE AS c INNER JOIN 
	Users AS u on u.Id = c.Id
ORDER BY u.Reputation DESC

fork query

created feb 23 Edward.Anil.Joseph