0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select U.DisplayName, 
-- U.Reputation, U.LastAccessDate,
COUNT(P.Id) As PostCount
     from Users as U
inner join 
        Posts as P
On P.OwnerUserID=U.Id
     
        where P.CreationDate > GETUTCDATE()-30 and
      U.LastAccessDate > GETUTCDATE()-30

GROUP BY U.DisplayName order by PostCount DESC;

fork query

edited jun 3 15 Deer Hunter

created mar 6 14 AJ Henderson