Q&A for professional and enthusiast programmers
WITH Raw AS ( SELECT PostId, COUNT(*) AS [Times Deleted] FROM PostHistory WHERE PostHistoryTypeId = 12 AND Comment LIKE 'Scheduled: %' GROUP BY PostId HAVING COUNT(*) >= 2 ) SELECT Raw.PostId AS [Post Link], Posts.CreationDate, Posts.Score, Raw.[Times Deleted] FROM Raw, Posts WHERE Raw.PostId = Posts.Id ORDER BY Posts.Id DESC