This query returns the number of edits you still need to
get the Copy Editor badge.
Q&A for apps, scripts, and development with the Stack Exchange API
-- Copy Editor Progress
-- This query returns the number of edits you still need to
-- get the Copy Editor badge.
DECLARE @userid int = ##UserId##
SELECT 500 - COUNT(*) AS EditsLeft
FROM PostHistory ph
WHERE PostHistoryTypeId IN (4,5)
AND PostId NOT IN (
FROM Posts p
WHERE p.OwnerUserId = ph.UserId
AND UserID = @userid
GROUP BY PostID
) AS bar