with tb1 as (select block_timestamp,

signer_id,

from near.core.fact_actions_events

where action_name = 'DeployContract'

and block_timestamp::date >= '2024-09-01'

and block_timestamp::Date < '2024-11-01'

select trunc(block_timestamp,'day') as daily,

case when block_timestamp::Date < '2024-10-01' then 'September' else 'October' end as type,

count(DISTINCT tx_hash) as "Deployed Contracts",

rank() over (partition by type order by daily asc) as day

from tb1

group by 1,2