Q&A for spacecraft operators, scientists, engineers, and enthusiasts
SELECT PostHistory.PostId, ( SELECT COUNT(Hist.Id) FROM PostHistory as Hist WHERE Hist.PostId = PostHistory.PostId AND Hist.PostHistoryTypeId = 50 AND Hist.CreationDate < '2021-12-01' ) as 'Total Bumps' FROM PostHistory WHERE PostHistory.PostHistoryTypeId = 50 AND PostHistory.CreationDate > '2021-01-01' AND PostHistory.CreationDate < '2021-12-01' GROUP BY PostHistory.PostId ORDER BY 'Total Bumps' DESC