0

Please login or register to vote for this query.

(click on this box to dismiss)

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

WITH edits AS (
  SELECT ph.Id, ph.CreationDate, ph.UserId, ph.PostId
  FROM PostHistory ph
  INNER JOIN Posts p 
  ON (p.Id = ph.PostId AND p.OwnerUserId != ph.UserId)
  WHERE ph.CreationDate > '2017-01-01'
), 
dates AS (
  SELECT CAST(CreationDate AS DATE) as CreationDate
  FROM edits 
  GROUP BY CAST(CreationDate AS DATE) 
)

SELECT TOP 5 UserId, CAST(CreationDate AS DATE), COUNT(Id)
FROM edits 
GROUP BY UserId, CAST(CreationDate AS DATE)
--PIVOT ( 
  --COUNT(Id) for actions_per_day in (dates)
--)

view current version

edited apr 1 20

created mar 31 20 Nicholas.Hoernle