Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language
With Question(id, user_id, title, body, creation_date, closed_date) as ( select Id, OwnerUserId , Title, Body, CreationDate, ClosedDate from Posts WHERE PostTypeId = 1 and ClosedDate is null and CreationDate >= '2019-01-01' and CreationDate <= '2019-11-01' and AnswerCount > 0 ) SELECT count(*) FROM Posts AS p, Question as q WHERE PostTypeId = 2 and p.ParentId = q.id and p.OwnerUserId != q.user_id