Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language
With Question(id, user_id, title, body, tags, creation_date, closed_date) as ( select Id, OwnerUserId , Title, Body, Tags, CreationDate, ClosedDate from Posts WHERE PostTypeId = 1 and ClosedDate is null and CreationDate >= '2019-10-25' and CreationDate <= '2019-11-01' ) SELECT p.Body, q.tags, 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