c.address as "contract address",

--c.created_block_timestamp as "deployment date",

c.creator_address as "creator address",

COUNT(DISTINCT t.tx_hash) as "total interactions"

FROM mezo.testnet.dim_contracts c

LEFT JOIN mezo.testnet.fact_transactions t

ON c.address = t.to_address

WHERE c.created_block_timestamp >= (

SELECT MIN(block_timestamp)

FROM mezo.testnet.fact_transactions

)

GROUP BY 1,2

ORDER BY 3 DESC

LIMIT 5;