0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT
  p.Title,
  p.score,
  p.ViewCount,
  p.AnswerCount,
  p.CommentCount,
  LEN(p.body) as ques_size,
  p.favoritecount,
  p.id,
  u.reputation as user_repo,
  u.creationdate as user_join_date,
  DATEDIFF(MINUTE, p.CreationDate, a.CreationDate) as QATimeGap
FROM
  posts AS p,
  posts AS a,
  users AS u
WHERE
  p.id = a.parentId
  AND p.owneruserid = u.id
  AND a.creationdate = (
    SELECT MIN(tau.creationdate)
    FROM posts tau
    WHERE tau.parentID = p.id
    GROUP BY tau.parentID
  )
  AND p.title LIKE '%Java HttpServer/HttpExchange GET%';

fork query

edited dec 3 23

created dec 2 23 anonymous