instruction: Lists users in descending order of number of rollback edits they've done.. Lists users in descending order of number of rollback edits they've done.
response: SELECT r.UserId AS "user_link", COUNT(*) AS "Count" FROM (SELECT h.UserId FROM PostHistory AS h WHERE h.PostHistoryTypeId IN (7, 8, 9) AND NOT h.UserId IS NULL GROUP BY h.UserId, h.RevisionGUID) AS r GROUP BY r.UserId ORDER BY 'Count' DESC