Q&A for professional and enthusiast programmers
SELECT COUNT(*) FROM Posts p WHERE p.PostTypeId = 1 -- questions only AND EXISTS ( SELECT * FROM PostHistory ph WHERE ph.postId = p.Id AND ph.PostHistoryTypeId = 10 -- closed )