,case

when DECODED_LOG:amountOfETH/1e18 >0 and DECODED_LOG:amountOfETH/1e18<=1 then 'Below One ETH'

when DECODED_LOG:amountOfETH/1e18 >1 and DECODED_LOG:amountOfETH/1e18<=5 then '1~5 ETH'

when DECODED_LOG:amountOfETH/1e18 >5 and DECODED_LOG:amountOfETH/1e18<=10 then '5~10 ETH'

when DECODED_LOG:amountOfETH/1e18 >10 and DECODED_LOG:amountOfETH/1e18<=20 then '10~20 ETH'

when DECODED_LOG:amountOfETH/1e18 >20 and DECODED_LOG:amountOfETH/1e18<=50 then '20~50 ETH'

when DECODED_LOG:amountOfETH/1e18 >50 and DECODED_LOG:amountOfETH/1e18<=100 then '50~100 ETH'

when DECODED_LOG:amountOfETH/1e18 >100 then 'Up To 100 ETH' end as dis_volume

,count(distinct DECODED_LOG:receiver) as users

,count(distinct TX_HASH) as txs

from ethereum.core.ez_decoded_event_logs

where CONTRACT_ADDRESS ='0x889edc2edab5f40e902b864ad4d7ade8e412f9b1'

and CONTRACT_NAME='Lido: stETH Withdrawal NFT'

and EVENT_NAME='WithdrawalClaimed'

and TX_STATUS='SUCCESS'

and dis_volume is not null

group by 1,2

order by 3 desc