COUNT(DISTINCT signer_id) AS "deployers",

COUNT(DISTINCT tx_hash) AS "total contracts deployed",

COUNT(CASE WHEN receipt_succeeded = TRUE THEN 1 END) AS "successful deploys",

COUNT(CASE WHEN receipt_succeeded = FALSE THEN 1 END) AS "failed deploys",

(COUNT(CASE WHEN receipt_succeeded = TRUE THEN 1 END) * 100.0) /

NULLIF(COUNT(DISTINCT tx_hash), 0) AS "deployment success rate"

near.core.fact_actions_events

action_name = 'DeployContract'

--AND signer_id NOT IN ('lockup.near', 'deposit.aurora', 'near');