tx_receiver ,

deposit/pow(10,24) as near_amount

from near.core.fact_Transfers

where (tx_signer ilike '%sweat_welcome.near%' or tx_signer ilike '%sweat_oracle_%' ) and status = 'TRUE'

and tx_receiver not in ('sweat_welcome.near'))

,

sweat_wallet as ( select DISTINCT tx_receiver

from wallet

where near_amount <= 0.05)

select

count(DISTINCT(tx_signer)) as sweat_user,

count(DISTINCT(tx_hash)) as sweat_tx,

sweat_tx/sweat_user as "Avg Txns Per Address"

from near.core.fact_transactions

where tx_signer in ( select tx_receiver from sweat_wallet)

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