SELECT

signer_id AS "deployers",

COUNT(DISTINCT tx_hash) AS "total_deployments",

COUNT(DISTINCT CASE WHEN receipt_succeeded = TRUE THEN tx_hash END) AS "successful_deployments"

FROM

near.core.fact_actions_events

WHERE

action_name = 'DeployContract'

GROUP BY

signer_id

d."deployers",

d."total_deployments",

d."successful_deployments",

(d."successful_deployments" / d."total_deployments") * 100 AS "success_rate"

deployer_stats d

ORDER BY

"total_deployments" DESC

LIMIT 10;