farid-c9j0VMUntitled Query
9
1
2
3
4
5
6
7
›
⌄
select wallet , total_staked_eth , ifnull(balance,0) as balance ,
case when balance/total_staked_eth < 0.0001 then 'Fully Sold'
when (balance/total_staked_eth >= 0.0001 and balance/total_staked_eth < 1) then 'Partially Sold'
else 'Fully HODL' end as status
from lido_eth_stakes left join wallets_balance
on wallet = user_address
)
Run a query to Download Data