Q&A about the site for expert genealogists and people interested in genealogy or family history
WITH post_comments AS ( SELECT postid, MIN(creationdate) AS first_comment FROM comments GROUP BY postid ) SELECT p.id AS post_id, p.viewcount AS view_count, DATEDIFF(hour, p.CreationDate, pc.first_comment) AS response_time_in_hours FROM posts p INNER JOIN post_comments pc ON p.id = pc.postid WHERE p.CreationDate >= '2021-05-03' AND p.CreationDate <= '2021-05-10' AND (p.ClosedDate IS NULL OR p.ClosedDate <= '2021-05-10') AND p.posttypeid = 1; -- Ensure we are only considering questions (posttypeid = 1)