0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

select
  OwnerUserId as [User Link], 
  Id as [Post Link], 
  count(*) as [Racha], 
  sum(Score) as [Puntuacion], 
  sum(ViewCount) as [Visitas], 
  sum(AnswerCount) as [Respuestas]
from Posts
where 1=1
--and CreationDate between cast('2017-10-16 00:00:00' as datetime) and cast('2017-10-23 00:00:00' as datetime)  
and CreationDate > cast('2017-10-16 00:00:00' as datetime)
and PostTypeId = 1
group by OwnerUserId, Id
order by 3 desc, 4 desc, 5 desc, 6 desc

view current version

edited oct 23 17

created oct 18 17 walen