0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited nov 22

created nov 22 jon.doe32564