Q&A for users, experts, and developers of the Tezos blockchain project
with answered_cte AS ( SELECT q.Id AS qid, q.CreationDate AS created, MIN(a.CreationDate) AS answered FROM Posts q INNER JOIN Posts a ON a.ParentId=q.Id WHERE (q.PostTypeId=1) and (q.AnswerCount>0) ---only question which have at least one answer and (a.OwnerUserId IN(##list?2,3,66,121,1409,2000,2926##)) ---restricted to these users GROUP BY q.Id, q.CreationDate ) SELECT top (##num?1000##) qid AS [Post Link], DATEDIFF(month, created, answered) AS Months, DATEDIFF(day, created, answered) AS Days, DATEDIFF(hour, created, answered) AS Hours, DATEDIFF(minute, created, answered) AS Minutes FROM answered_cte ORDER BY DATEDIFF(minute, created, answered) DESC