SELECT
tx_receiver,
COUNT(*)
FROM
near.core.fact_actions_events x
LEFT OUTER JOIN near.core.fact_transactions y ON x.tx_hash = y.tx_hash
WHERE x.tx_hash in (
select
tx_hash from near.core.fact_actions_events
where block_timestamp >= '2022-12-01' and action_name like 'DeployContract'
)
GROUP BY
1
ORDER BY
2 DESC
LIMIT 10