SELECT

owner_address,

SUM(olas_amount_usd) AS total_bonded_volume,

SUM(CASE WHEN is_redeemed = True THEN olas_amount_usd ELSE 0 END) AS total_redeemed_volume

FROM

crosschain.olas.ez_olas_bonding

GROUP BY

owner_address

),

user_percentage AS (

SELECT

owner_address,

total_bonded_volume,

total_redeemed_volume,

(total_redeemed_volume / total_bonded_volume) * 100 AS percentage_withdrawn

FROM

user_bonding_data

CASE

WHEN percentage_withdrawn BETWEEN 0 AND 25 THEN '0-25%'

WHEN percentage_withdrawn BETWEEN 25 AND 50 THEN '25-50%'

WHEN percentage_withdrawn BETWEEN 50 AND 75 THEN '50-75%'

WHEN percentage_withdrawn BETWEEN 75 AND 100 THEN '75-100%'

ELSE 'No redemption'

END AS redemption_range,

COUNT(owner_address) AS users_count,

SUM(total_bonded_volume) AS total_bonded_volume_in_range,

SUM(total_redeemed_volume) AS total_redeemed_volume_in_range

user_percentage

GROUP BY

redemption_range

ORDER BY

redemption_range;