select
date_trunc('month', created_block_timestamp) as month,
count(distinct address) as "Number of smart contracts deployed"
from berachain.testnet.dim_contracts
where month is not null
and created_block_timestamp::date >= '2024-06-09' -- Berachain officially launched version 2 of its testnet called bArtio
group by 1