SELECT
COUNT(DISTINCT signer_id) AS "deployers",
COUNT(DISTINCT tx_hash) AS "total contracts deployed",
CASE
WHEN COUNT(DISTINCT signer_id) = 0 THEN 0
ELSE COUNT(DISTINCT tx_hash) / COUNT(DISTINCT signer_id)
END AS "deployer efficiency (contracts per deployer)"
FROM
near.core.fact_actions_events
WHERE
action_name = 'DeployContract'