Q&A for speakers of other languages learning English
SELECT count (*) -- 'http://stackoverflow.com/posts/' + Convert(NVarchar(10), edit.PostId) + '/revisions|Revision History' AS [Revision Link] -- edit.PostId as [Post Link] ---count (distinct prev.RevisionGUID) as Revision FROM PostHistory edit