CASE

WHEN SUCCESS = 'true' THEN 'Successful'

ELSE 'Failed'

END AS nudge_status,

COUNT(DISTINCT TX_HASH) AS nudges_count

FROM

aptos.core.fact_transactions

WHERE

PAYLOAD_FUNCTION LIKE '%nudge::nudge%'

GROUP BY

nudge_status;