signer_id ,

sum(amount_usd) as usd

from near.core.ez_token_transfers

join near.core.fact_actions_events_function_call b using(tx_hash)

where to_address = 'v2.ref-finance.near'

and method_name = 'add_liquidity'

and transfer_type = 'nep141'

and args:pool_id = '3411'

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

group by 1)

select case when usd <10 then 'Less Than 10$'

when usd >=10 and usd<100 then '10$ - 100$'

when usd >=100 and usd<1000 then '100$ - 1000$'

else 'More Than 1000$' end as splitter,

count(DISTINCT signer_id) as users

from base

group by 1