sum(amount) as lended_amount

from solana.core.fact_transfers

where tx_to = '8RcZHucpVHkHWRRdMhJZsxBK9mqKSYnMKGqtF84U8YEo' -- MarginFi $bSOL Pool

and block_timestamp::date >= '2023-07-09'

group by 1)

select case when lended_amount <= 10 then 'Less Than 10 $bSOL'

when lended_amount > 10 and lended_amount <= 100 then 'Between 10 - 100 $bSOL'

when lended_amount > 100 and lended_amount <= 1000 then 'Between 100 - 1000 $bSOL'

else 'More Than 1000 $bSOL' end as splitter,

count(DISTINCT tx_from) as users

from base

group by 1