Questions answered by users with > X reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

DECLARE @Reputation int = ##Reputation##

SELECT Q.Id, Sum(IIF(U.Reputation >= @Reputation, 1, 0)) As HighRep, Sum(IIF(U.Reputation >= @Reputation, 1, 0)) AS LowRep
FROM Posts AS Q LEFT JOIN (Posts AS A INNER JOIN Users AS U ON A.OwnerUserId=U.Id) ON A.ParentId=Q.Id
WHERE Q.ParentID Is Null AND Q.CreationDate >  DateAdd(m, -1, GETDATE())
GROUP BY Q.Id

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results