Q&A for anime and manga fans
SELECT p.Id, p.CreationDate, n.NextId - p.Id - 1 AS 'Missing post ID', CONCAT('site://posts/', p.Id + 1, '/revisions') AS 'First missing post' FROM Posts AS p CROSS APPLY ( SELECT MIN(Id) AS NextId FROM Posts WHERE Id > p.Id ) n WHERE n.NextId - p.Id != 1 ORDER BY p.CreationDate