プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答
With Question(id, user_id, title, body, creation_date, closed_date) as ( select TOP 10000 Id, OwnerUserId , Title, Body, CreationDate, ClosedDate from Posts WHERE PostTypeId = 1 and ClosedDate is null and CreationDate >= '2019-03-01' and CreationDate <= '2019-04-01' and AnswerCount > 0 ORDER BY NEWID() ) SELECT p.Body, p.Id as A_id, concat(q.title, '. ', q.body) as Questions, q.id as Q_id, q.creation_date as Q_CreateDate FROM Posts AS p, Question as q WHERE PostTypeId = 2 and p.ParentId = q.id and p.OwnerUserId != q.user_id order by q.creation_date, q.id