0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

;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

edited feb 23

created feb 23 anonymous