Q&A for professional and enthusiast programmers
select count(1) as N from PostsWithDeleted a inner join Posts q on a.ParentId = q.Id where a.DeletionDate is not null