0

Please login or register to vote for this query.

(click on this box to dismiss)

Turnaround time & number of questions in group for Questions that are migrated between different sites and subsequently closed at their destination

Q&A for anime and manga fans

-- Migrated and Closed - Turnaround Time
-- Turnaround time for Questions that are migrated between different sites and subsequently closed at their destination

SELECT turnaround AS turnaround_hours, count(turnaround) as qty FROM (
   SELECT datediff(hh, ph.CreationDate, p.closeddate) as Turnaround
      FROM Posts p
      INNER JOIN PostHistory ph ON ph.PostId = p.Id
                 WHERE ph.PostHistoryTypeId = 17 AND ClosedDate IS NOT NULL
) T GROUP BY turnaround

fork query

created jun 1 11 voretaq7