from near.core.fact_actions_events as events

inner join near.core.fact_actions_events_function_call as functions

on events.tx_hash=functions.tx_hash

inner join near.core.fact_receipts as receipts

on receipts.tx_hash=functions.tx_hash

where

events.action_name = 'DeployContract' and method_name = 'new')

, activities as (select tx_receiver , block_timestamp::date as date from near.core.fact_transactions inner join developers

on receiver_id=tx_receiver

where date > CURRENT_DATE - interval '60 days' and tx_receiver!='8c50889fbcec2d14613b4ab670f36d60f89908f0dd02c8115b81e96ba224f6b4'

, active_developers as (select count(distinct date) as number_of_days_active , tx_receiver from activities

group by tx_receiver

having number_of_days_active > 45

select count(*) from active_developers