SELECT top 10 COUNT(BLOCK_HASH) as tx_count, TX_RECEIVER AS smart_contract
FROM near.core.fact_transactions a
join near.core.fact_actions_events b
on a.tx_hash =b.tx_hash
WHERE a.BLOCK_TIMESTAMP >=CURRENT_DATE -60
and action_name ilike 'DeployContract'
GROUP BY smart_contract
ORDER BY tx_count DESC