SELECT

tx_id,

CASE

WHEN ATTRIBUTE_KEY = 'validator' AND msg_type = 'unbond' THEN ATTRIBUTE_VALUE

ELSE NULL

END AS validator,

CASE

WHEN ATTRIBUTE_KEY = 'amount' AND msg_type = 'unbond' THEN

CAST(REPLACE(ATTRIBUTE_VALUE, 'usei', '') AS DECIMAL) / 1000000

ELSE NULL

END AS unstake_amount

FROM sei.core.fact_msg_attributes

WHERE msg_type = 'unbond'

AND (ATTRIBUTE_KEY = 'validator' OR ATTRIBUTE_KEY = 'amount')

SELECT

validator,

SUM(COALESCE(unstake_amount, 0)) AS total_unstaked_amount

FROM unbond_data

GROUP BY validator

HAVING SUM(COALESCE(unstake_amount, 0)) > 0;