COUNT(DISTINCT contract) AS new_contracts,

COUNT(*) AS tot_contracts

FROM (

SELECT

contract_address AS contract,

MIN(block_timestamp) AS min_date

FROM ink.core.fact_event_logs

WHERE tx_succeeded = 'TRUE'

GROUP BY contract_address

) subquery;