Q&A for information security professionals
select OwnerUserId as [User], day(CreationDate) as [Fecha], 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 and CommunityOwnedDate is null group by OwnerUserId, Id, day(CreationDate) order by 2, 3 desc, 4 desc, 5 desc