WITH reverts AS (
    SELECT
      revision_is_identity_revert as mw_history,
      IF(ARRAY_CONTAINS(revision_tags, 'mw-undo'), 1, 0) AS undo,
      IF(ARRAY_CONTAINS(revision_tags, 'mw-rollback'), 1, 0) AS rollback,
      IF(ARRAY_CONTAINS(revision_tags, 'mw-manual-revert'), 1, 0) as manual
    FROM wmf.mediawiki_history
    WHERE
      snapshot = '2022-05'
      AND wiki_db = 'enwiki'
      AND page_namespace = 0
      AND NOT page_is_redirect
      AND event_type = 'create'
      AND event_entity = 'revision'
      AND event_timestamp >= '2022-05-01'
      AND event_timestamp < '2022-06-01'  
)
SELECT
  mw_history,
  undo,
  rollback,
  manual,
  COUNT(1)
FROM reverts
GROUP BY
  mw_history,
  undo,
  rollback,
  manual

English Wikipedia May 2022 data (namespace 0; no redirects):
+----------+----+--------+------+--------+
|mw_history|undo|rollback|manual|# edits |
+----------+----+--------+------+--------+
|false     |0   |0       |0     |3100382 |  # edits that weren't reverts by any definition

# reverts captured in mediawiki history
# vast majority also show up as edit tags
# but some small proportion were manual and
# missed by mediawiki for some reason
|true      |1   |0       |0     |109548  |  # straightforward undos
|true      |0   |1       |0     |54032   |  # straightforward rollbacks
|true      |0   |0       |1     |49750   |  # straightforward manual reverts
|true      |0   |0       |0     |20827   |  # manual reverts found by mediawiki_history table but not identified by mediawiki

# reverts not captured in mediawiki history
# vast majority are undos where presumably the editor
# changed something too and so generated a unique hash
|false     |1   |0       |0     |7711    |  # undo
|false     |0   |0       |1     |8       |  # manual
|false     |0   |1       |0     |2       |  # rollback
+----------+----+--------+------+--------+

spark.sql("""
WITH reverted AS (
    SELECT
      revision_is_identity_reverted as mw_history,
      IF(ARRAY_CONTAINS(revision_tags, 'mw-reverted'), 1, 0) AS reverted
    FROM wmf.mediawiki_history
    WHERE
      snapshot = '2022-05'
      AND wiki_db = 'enwiki'
      AND page_namespace = 0
      AND NOT page_is_redirect
      AND event_type = 'create'
      AND event_entity = 'revision'
      AND event_timestamp >= '2022-05-01'
      AND event_timestamp < '2022-06-01'  
)
SELECT
  COUNT(1) AS num_edits,
  mw_history,
  reverted
FROM reverted
GROUP BY
  mw_history,
  reverted
ORDER BY
  mw_history,
  num_edits DESC
""").show(100, False)

+---------+----------+--------+
|# edits  |mw_history|reverted|
+---------+----------+--------+
|3037145  |false     |0       |  # most edits aren't reverted (yay!)

# most reverted edits are captured by mediawiki_history and mw-reverted tags (yay!)
|275158   |true      |1       |  

# ~10% of reverted edits missed by mw-reverted; likely because its criteria are much more complicated: https://www.mediawiki.org/wiki/Manual:Reverts#Conditions_for_execution
|22487    |true      |0       |  

# small number of edits are tagged as reverted but missed in mediawiki_history (~3%). this about matches the number of mw-undo edits that were presumably partial and therefore missed by mediawiki_history (7711 -- see data from previous comment). so I assume that's what is going on here -- i.e. mediawiki_history doesn't detect partially-reverted edits as reverted.
|7470     |false     |1       | 
+---------+----------+--------+