Migrated and Closed - Turnaround Time/counts

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

Stack Overflow

Q&A for programmers

-- 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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached