SELECT
signer_id AS "deployers",
COUNT(DISTINCT tx_hash) AS "total contracts deployed"
FROM
near.core.fact_actions_events
WHERE
action_name = 'DeployContract'
AND receipt_succeeded = TRUE
GROUP BY
"deployers"
ORDER BY
"total contracts deployed" DESC
LIMIT
7;