1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professors, theologians, and those interested in exegetical analysis of biblical texts

DECLARE @SecondsThreshold AS Int = ##SecondsThreshold:int?190##;
 -- 180+10 based on answering rate-limit: https://meta.stackexchange.com/a/164900/997587
WITH Pool AS (
  SELECT Id, ParentId, CreationDate, Body, OwnerUserId
  FROM PostsWithDeleted
  WHERE
    PostTypeId = 2 -- answer
    AND CreationDate >= '2022-11-30' -- https://openai.com/blog/chatgpt/
),
TimeDiff AS (
  SELECT
    A.Id,
    A.ParentId,
    DATEDIFF(
      second,
      LAG(A.CreationDate, 1, DATEFROMPARTS(2022,11,29)) OVER (
        PARTITION BY A.OwnerUserId
        ORDER BY A.CreationDate ASC
      ),
      A.CreationDate
    ) AS Seconds,
    Body,
    A.OwnerUserId
  FROM Pool A
)
SELECT
  A.Id AS [Post Link],
  A.Seconds,
  Q.Tags,
  A.OwnerUserId AS [User Link],
  U.Reputation AS UserRep,
  U.CreationDate AS UserBday,
  PATINDEX('% help%', A.Body) AS HelpIdx,
  A.Body
FROM TimeDiff A
JOIN Users U ON U.Id = A.OwnerUserId
LEFT JOIN PostsWithDeleted Q ON Q.Id = A.ParentId
WHERE
  A.Seconds < @SecondsThreshold
;

fork query

created dec 5 22 starball