select

OWNER,

BALANCE,

row_number() over(partition by owner order by block_timestamp desc) as rank

from solana.core.fact_token_balances

where SUCCEEDED

and mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

),

Holders as (

select owner as Holder_Address,

BALANCE

from address_balance

where balance > 0

and rank = 1

select

Program_id,

case when Program_id = 'zF2vSz6V9g1YHGmfrzsY497NJzbRr84QUrPry4bLQ25' then 'Mango'

when Program_id = 'abfcSQac2vK2Pa6UAJb37DzarVxF15bDTdphJzAqYYp' then 'abfcS...qYYp'

else Label end as Project,

count(DISTINCT tx_id) as N_TXs,

count(DISTINCT signers[0]) as N_Users,

N_Users / (select count(DISTINCT Holder_Address) from Holders) * 100 as PCT_OF_HOLDERS

from solana.core.ez_events_decoded

left join solana.core.dim_labels on ez_events_decoded.program_id = dim_labels.ADDRESS

where signers[0] in (select Holder_Address from Holders)

and block_timestamp >= current_timestamp - interval '30 Days'

and SUCCEEDED

and EVENT_TYPE in (

'depositReserveLiquidityAndObligationCollateral',

'withdrawObligationCollateralAndRedeemReserveCollateral',

'lendingAccountWithdraw',

'lendingAccountDeposit',

'lendingAccountWithdrawEmissions',

'lendingAccountBorrow',