list1 as (

select tx_receiver as user_address, (deposit / pow(10, 24)) as near_amount

from near.core.fact_transfers

where (

tx_signer = 'sweat_welcome.near' or

tx_signer like '%sweat_oracle_%'

)

and status = 1

having near_amount <= 0.055

),

list2 as (

select count(distinct (user_address)) as all_wallets

from list1

),

list3 as (

select count(distinct (tx_signer)) as active_wallets

from near.core.fact_transactions

where tx_signer in (select distinct (user_address) from list1)

and block_timestamp::date >= current_date - 14

select list2.all_wallets, list3.active_wallets from list2 inner join list3